Monthly Archives: September 2011

Fancy a decent Compatibility Matrix?

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?

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