I recently received a question about the storage of nonclustered index keys. I am assuming you are aware of the fact that if your table has a clustered index, SQL Server uses the clustered index key (all of its columns, if it is a composite index) as a 'bookmark' in your nonclustered indexes,  to allow your nonclustered indexes to uniquely ...

  I had a fantastic time at the SQL Server 2008 JumpStart last week in Redmond. Getting to spend a whole week learning new stuff from Kim and Paul was awesome! My favorite topic was one from Paul called ''DBCC CHECKDB Fundamentals in only 487 slides.'' Although I am still absorbing much of that information, it did remind me of a DBCC CHECKDB ...

SQL Server 2005 allows rows to include variable length columns which do not actually fit in the maximum row size of 8060 bytes. I previously posted about row-overflow columns, and discussed the maximum number of such columns that you could have in a single table. You can read that post here. Just recently I received another question that ...