Daily Archives: May 23, 2011

Hints Are Not Always Better

I have always thought that an index seen was preferable to an index scan. It seems like the general rule that so many DBAs and developers follow, looking to convert every scan in an execution plan to a seek. Often … Continue reading

Posted in Editorial | Tagged | Comments Off on Hints Are Not Always Better

Collation Conflicts in a SQL Server Join

I went to run this query recently: select TOP 10 * from users a inner join Banned b on a.username = b.username and got this lovely message. I’d seen that message before, so I knew what was wrong. The collations … Continue reading

Posted in Blog | Tagged , , | 1 Comment