SQL Myths

Paul Nielsen — Sat, 29 Dec 2007 00:17:00 GMT

It’s amazing what people believe. Here are some SQL beliefs or strange ideas that I’ve encountered in the past year.

· The column order isn’t important, so long as the column is in the index anywhere, SQL Server can use that column to optimize a where clause. (This one came from a system with only one table (about 25 columns), and it had only one index – a 15 column clustered PK)

· Table variables are only in memory (a common misconception)

· We have to run Enterprise Edition because we need 4 CPUs (thinking they need Ent Ed when Std will do is another common misconception)

· You can pass an array into a proc using dynamic pointers (this one from a MCS SQL consultant!)

I’m sure you've heard a few as well, so please add to the list…

Paul Nielsen : SQL Myths

SQL Myths