THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Storage » DBCC   (RSS)
  • Geek City: Nonclustered Index Keys

    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 ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 16, 2008
  • Geek City: DBCC's Hidden Snapshot

      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 ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 10, 2008
  • Geek City: Detecting Overflowing Columns

    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 ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 9, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement