SQL Server The Truth – Rebuilding a clustered index does not rebuild the non clustered indexes

(Simon Sabin) It used to be fact that the leaf page of a non-clustered index pointed to the row for the page, because it pointed to the file, page and row if the file or page of the row changed the nonclustered index had to be updated.

Read More - Register for Free Membership