Tag Info

New answers tagged


The clustered index IS the table. In the classic phone book analogy where everything is ordered by Lastname, Firstname there's not some other book that the phone book refers to. The Phone book IS the book, and it's in that order. When you have a clustered index, it contains all the data for all the columns in the table, ordered by the key you pick. In the ...


On the question of the size of things, first of all you said that you shrank a database, so that would reduce the DB size of the space that was discarded during the shrink. John M also provided some clarification. Regarding the numbers in the bottom picture, they are: select (2585832 / 1024.0) /* KB from the Reserved in the bottom picture to MB */ ...

Top 50 recent answers are included