I am so excited that me have me high performance storage Thomas Kejser from the Microsoft SQLCAT coming to SQLBits VI. If you are dealing with large volumes of data and you want it to perform then attending Thomas's session is a must. Are you currently Read More (read more)

Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate the feature, here’s a bit of background about lock escalation and lock granularities. Background SQL Server has a ...