Clustered Index Rebuilds Affecting Non-Clustered Indexes
Another nifty note about indexing. One of the more popular interview questions for technical folks is the various effects a change to a clustered index can have on nonclustered indexes. This post clears some of that up:
The answer may surprise you. Essentially, altering a clustered index does not affect the nonclustered indexes. Dropping and recreating do.