Changes in lock escalation in SQL Server 2008 R2

If you are still using an older SQL Server version such as 2005 (or even 2000), there's one change in lock handling in SQL Server 2008 that makes things work differently in the latest version.

According to a Connect post, lock escalation with INSERT statements now works differently. Depending on your situation, this might or might not affect your application. It's better to be safe than sorry, though.