Use ALTER INDEX ... REBUILD | REORGANIZE instead of DBCC DBREINDEX (it is deprecated and will be...

DBCC REINDEX is deprecated in SQL Server 2005 and 2008. It will be removed from the next version, you should use ALTER INDEX instead. All logged operations will...

My guess (FWIW) is that the question is about moving a table to a secondary filegroup (typically named *.NDF)

If so, the following MSDN article explains files and filegroups and links...

MSDN: Detecting and Ending Deadlocks contains full information on the trace flags mentioned.

Unsure where Abhay has seen a table-level UPDATE lock.

Also unsure how extent locks (which are only used for...

I think that makes $0.04 in total 😉

P.S. Enjoyed your article today Grant

Oh, while I think of it, one thing you might find interesting is that the 'wait resource' associated with a lock - a string like (0801c4e1f5e4) for example - can...

The deadlock graph you provided shows only the HoBt (heap or B-tree) ID involved - which for SQL 2005 will be the same as the partition ID in sys.partitions. ...

The simple answer is that SQL Server only guarantees to return zero on success - but then you knew that 😉

If the stored procedure doesn't provide an explicit return value...

Sheng (6/23/2009)

---

In the below screen shot, it seems a same index is held X and U by different process. But according to the Lock Compatibility table, this should not happen.

And...

I know I just seem to be posting links here, but http://technet.microsoft.com/en-us/library/cc966413.aspx is a Microsoft white paper on SQL Server 2005 Performance Tuning using the Waits and Queues methodology. ...

Hey Ed,

Maybe we read the original post differently, but:

Notice the word 'complains' not 'complaints' - I took this...

From the same white paper:

http://technet.microsoft.com/en-us/library/cc966413.aspx

---

If IO_stalls is inordinately high for one or more files, it is possible that there is either a disk bottleneck or that high reads and writes...

RBarryYoung (6/24/2009)

---

The funny thing is about a week after I submitted that, I came up with a cople of different compression schemes that are almost twice as efficient. I...

Abhay,

1 Using CONVERT with a style parameter when converting date-time to string is more robust and explicit.

2 Your statement does not work correctly...

Gail's method has the distinct advantage of being able to seek using an index. The other methods would have to scan the table or the whole index.

There was a...