Subscribe to this blog
Archives: May 2011
Locking While Dropping or Altering an Index
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking so I had the bright idea of disabling the indexes first, then dropping. Well, that didn’t help, even when setting DEADLOCK_PRIORITY to LOW. I ended up waiting until early morning… Read more
5 comments, 884 reads
Posted in Eric Humphrey on 12 May 2011