February 2007 - Posts

• 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, Read More... Posted Tuesday, February 27, 2007 3:10 PM by khen1234 | 4 Comments

• 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 Read More... Posted Saturday, February 10, 2007 1:22 AM by khen1234 | 15 Comments