Categories
Posts By Month
-
Recent Posts
Archives
- May 2012 (1)
- April 2012 (4)
- March 2012 (2)
- February 2012 (1)
- January 2012 (2)
- December 2011 (1)
- November 2011 (2)
- October 2011 (6)
- September 2011 (2)
- August 2011 (3)
- July 2011 (3)
- June 2011 (4)
- May 2011 (2)
- April 2011 (2)
- March 2011 (5)
- February 2011 (7)
- January 2011 (6)
- December 2010 (7)
- November 2010 (5)
- October 2010 (7)
- September 2010 (8)
- August 2010 (3)
- July 2010 (5)
- June 2010 (1)
- May 2010 (5)
- April 2010 (4)
- February 2010 (2)
- January 2010 (2)
- December 2009 (6)
- November 2009 (5)
- October 2009 (3)
- September 2009 (1)
- July 2009 (5)
- June 2009 (1)
- May 2009 (1)
- March 2009 (3)
Blogroll
Latest Tweets
- Pleased that one of my #sql 2012 connects has been marked as fixed after a bit of gentle persuasion is.gd/iZ3UOC 1 day ago
- @buckwoody Yeah I did mine at 24hop & sqlsat, but loved yours Buck. Even the Stones thought yours was awesome. cc. @TSQLNinja 1 day ago
- @TSQLNinja Pretty sure Mick "stole" it from you too ;) @buckwoody 1 day ago
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
