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…
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Paul Nielsen
Paul Nielsen believes SQL is the romance language of data. As such he’s a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of SQL Server Bible series (Wiley). As a data architect, he developed the concepts of Smart Database Design and Nordic – an open source O/R dbms for SQL Server. He lives in Colorado Springs.