Browse by Tags

• analysis
• best practice
• blogs
• clustered
• hardware
• index
• indexes
• links
• msdn
• performance
• performance monitoring
• reorganize
• schedule
• schema
• tempdb

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

DMVs to provide state of TEMPDB during a performance tuning analysis
14 August 07 06:55 AM | SQL Master | 5 Comments   

TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's memory & processor are coping up. Though Read More...

Filed under: performance, sql server, rebuild, hardware, index, tempdb, analysis

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