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 » Internals » storage   (RSS)
Showing page 2 of 2 (13 total posts)
  • 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: 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
  • Geek City: My New Favorite Tool - SQL Internals Viewer

    At least, I think it might become my new favorite tool.  J One of my readers created a tool to graphically display database storage internals, like allocation information, actual page contents, etc. This is just the tool I would have wanted to write if I ever got back to doing any programming. Here's what the author, Danny ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 19, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement