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:
Does rebuilding a clustered index rebuild nonclustered indexes
The answer may surprise you. Essentially, altering a clustered index does not affect the nonclustered indexes. Dropping and recreating do.