During a database design there has been an interesting discussion that will there be any performance addition in adding a second non-clustered index on a Globally Unique ID ( GUID ) column that has already a unique clustered index. IF needed you need to consider the usage of GUID column carefully, to...
Does rebuilding a clustered index rebuild nonclustered indexes? I have discussed this question with one of SQL Server MVP recently, eventually both were correct to the point. Lately I have found KhenBlog on the subject, interesting....( read more )