The additions or changes in SQL Server 2008 R2 are mostly BI related but there is one I just became aware of that serves a more general purpose but at the same time is fundamental in how the storage engine works related to locking.  I won’t rehash (pun intended) what Sunil Agarwal wrote in the below listed blog but in a nut shell they ...