Section 6 - New SQL Engine Features
Today we talked about
the new SQL Data Types (varbinary, varchar(max)),
how to keep readers from blocking writers and writers from blocking reader using the new isolation and versioning features
Enhanced Triggers and Notifications
New new BULK INSERT capabilities using the newer drivers
Ways to enhance the Query Execution plan using hints and optimizations
Here is the sample code and slides for you offline perusal - http://www.neudesic.com/uploads/steve_muise/06_EngineFeatures.zip