Browse by Tags

SQL Server indexing - when to reorganize or rebuild?

Published 21 January 8 4:30 AM | SSQA.net

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...

Filed under: sql server, indexes, msdn, blogs, rebuild, schema, best practice, schedule, links, performance monitoring, reorganize

Does rebuilding a clustered index rebuild nonclustered indexes?

Published 25 June 7 3:45 PM | SSQA.net

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 ) Read...

Filed under: sql server, performance, indexes, rebuild, clustered