Monthly Archives: September 2011

Fancy a decent Compatibility Matrix?

Posted on September 27, 2011 by

Have you ever taken a look at Microsoft’s published compatibility matrix for SQL Server lock compatibility? If you have, then I don’t need to tell you that it sucks in a very big way. Have no fear, I have painstakingly … Continue reading →

Posted in sql, SQLServerPedia Syndication, tuning | 6 Comments

When should you use NOLOCK?

Posted on September 14, 2011 by

Well the quick answer to that question is never. And there you have it, the quickest blog post in history (perhaps!). …Except that I should really have said “When should you use READUNCOMMITTED isolation or hint?” and then the question … Continue reading →

Posted in performance, scale-out, sql, SQLServerPedia Syndication | 2 Comments