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 » pages » DBCC » storage   (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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement