http://www.sqlservercentral.com/blogs/james-sql-footprint/2013/01/04/row-of-nonclustered-index-page/

Printed 2014/08/22 08:01AM

Row of nonclustered index page

By jamesxu98918, 2013/01/04

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.




Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.