One of those… “Best features you’ll never see”.
I love reading the blogs from SQLCat (SQL Server Customer Advisory Team) and from the SQL Server Storage Engine group; any time you can get information from the guys and gals that work with the internals is worth stopping to take note. One post that I saw from the Storage Engine team this week that struck my interest was about improved functionality with locks, locking, and concurrency that is new to SQL Server 2008 R2. It’s located here and is really an interesting post.
It’s cool to see that SQL Server is still doing everything possible to scale; the blog post that I just did on concurrency and locking in partitions demonstrates yet another improvement that we’ll all appreciate at some point down the road. It’s also interesting to see that that as the number of rows and size of datasets increases SQL Server behaves in different ways, and sometimes these problems just don’t ‘pop out’ until a lot of data is presented. Check out their post and let me know what you think.
Lee
-------------------
This dude needs to read more SQLCat/SQL Storage articles.
http://blogs.msdn.com/sqlserverstorageengine/archive/2010/01/18/improvement-in-minimizing-lockhash-key-collisions-in-sql-server-2008r2-and-its-impact-on-concurrency.aspx
d961a2ea-1e6e-4410-8a89-7e99d5db91fb|0|.0