Archives for December, 2011

Missing join predicate

A simple typo can have serious consequences. SELECT * FROM t1 INNER JOIN t2 ON t1.c1=t1.c1 Generates a ‘missing join predicate’ warning and a Cartesian product. In our case filling up 500GB TEMPDB space and a never ending query. Some good advice, check your query plan for ‘missing join predicate’ warnings. Advertisements

IBM Client Access V7R1

 I just spent 2 days troubleshooting the installation of the IBM Client Access V7R1 ODBC driver on SQL Server 2008 R2. So if you need to install or upgrade this ODBC driver, here are some tips. – Before starting the uninstallation, stop all SQL Server services – Use cwbunins.exe instead of “add/remove programs” to remove current […]