SQL Server 2008 Partition Level Locking