SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

James' SQL Footprint

Love SQL Server, Love life.


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

Loading comments...