Does rebuilding a clustered index rebuild nonclustered indexes?

This came up yesterday with one of our support engineers, so I thought I’d post a brief entry on it.  On SQL Server 2005, using ALTER INDEX…REBUILD to rebuild a clustered index does not rebuild its nonclustered indexes by default.  If you think about it, it makes perfect sense—the clustered keys, which are the record…

4

Update to the latest book’s CD

Many have noted that there are some files missing from the CD accompanying my latest book, SQL Server 2005 Practical Troubleshooting.  My apologies for that.  We’ve just posted an update to the book’s CD at http://www.khen.com/sspt.htm.  Note:  you’re welcome to grab the book’s CD regardless of whether you’ve actually purchased the book—we’re making it available…

15