Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James' SQL Footprint

Love SQL Server, Love life.

Row of nonclustered index page

Below is the formula of calculating the row size of non-clustered index page




















so unique non-clustered index created on unique clustered index use smallest space, while non-unique non-clustered index created on non-unique clustered index use largest space.



Comments

Leave a comment on the original post [jamessql.blogspot.com, opens in a new window]

Loading comments...