Duluth, GA
+ 678-753-4494
contact@datahills.us

Sql Server: Does rebuilding clustered index automatically rebuild nonclustered indexes

  • Posted by Sqltimes
  • On January 18, 2014
  • 0 Comments
When you have large tables in your database you want to plan maintenance strategically. Its a fine balance that you plan carefully to make sure that you Perform necessary maintenance successfully But not cause any blocking to table access Dependent nonclustered index are rebuilt (if needed) or not rebuild. What commands does Sql Server provide […]
Read More
 

How to rebuild HEAP tables including its nonclustered indexes

  • Posted by Sqltimes
  • On January 18, 2014
  • 0 Comments
Heap tables are present in some databases, they are not necessarily what we prefer, but they exist. We need to include them into our maintenance activities to keep the performance high. Question How do we rebuild heap tables Does rebuilding heap, automatically rebuild the dependent non-clustered indexes Let’s take an example: Create a sample heap […]
Read More