THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Hints   (RSS)
  • Geek City: A Hint of Degrees

    This is just a quick post to describe a test I just ran to satisfy my own curiosity. I remember when Microsoft first introduced the query hint OPTION (MAXDOP N). We already had the configuration option ‘max degree of parallelism’, so there were lots of questions about how the hint interacted with the configuration option. Some people thought the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 3, 2014
  • Pros and Cons of Using Read-Uncommitted and NoLock

    Definitions Read-Uncommitted Isolation Level The read-uncommitted isolation level is the least restrictive isolation level within SQL Server, which is also what makes it popular for developers when looking to reduce blocking. Blocking is “typically” not an issue when using this isolation level because the query will not request shared (S) locks ...
    Posted to Tamarick Hill (Weblog) by Tamarick Hill on May 6, 2013
Privacy Statement