Friday, July 20, 2007 - Posts

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

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes

posted Friday, July 20, 2007 10:32 AM by SimonSabin with 0 Comments

SQL Server The Truth - Instant file initialisation

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Instant file initialisation
The new RSS feed is here

This is the first in a series of posts that are aimed at dispelling myths and beliefs as to how SQL Server operates. I have interviewed too many people and have been in too many sessions where statements are made as though they are fact when in reality they are not. Often the reason is due to a change in behaviour between versions or a mis-interpretation of some information.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Instant file initialisation

posted Friday, July 20, 2007 9:26 AM by SimonSabin with 0 Comments