Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Update partition table without locking

Author  Topic 

chih
Posting Yak Master

154 Posts

Posted - 2009-08-19 : 02:01:23
Hi All,
I created a partition table with different conditions allocated to different file groups Fg1,fg2 and Fg3.

It happened locking issue when I want to do the follwoing update at the same time
-move all records (update condition) from Fg3 to Fg2
-update some records in Fg2

Any idea how to solve it?
   

- Advertisement -