Browse by Tags

• best practice
• blogs
• clustered
• links
• msdn
• performance
• performance monitoring
• reorganize
• schedule
• schema
• sql server

SQL Server indexing - when to reorganize or rebuild?
21 January 08 03:30 AM | SQL Master | 4 Comments   

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

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

Does rebuilding a clustered index rebuild nonclustered indexes?
25 June 07 01:45 PM | SQL Master | 1 Comments   

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

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