Where are double-linked lists for indexes stored in SQL Server 2005?

Posted on 2009-07-13
Medium Priority
Last Modified: 2012-05-07
Where are double-linked lists for indexes stored in SQL Server 2005? Are they on disk, referenced a system table?  It doesn't look as if they're referenced from sysindexes.
Question by:bmaxey
1 Comment
LVL 75

Accepted Solution

Aneesh Retnakaran earned 2000 total points
ID: 24841599
of course they are stored in the disk, if you have a Clustered index, the Physical storage order will be in the same order as CI

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question