Maintenance and Management

SQLServerCentral Article

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

  • Article

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.

4.92 (12)

You rated this post out of 5. Change rating

2018-05-18 (first published: )

4,916 reads

Blogs

From Couch-Potato to Triathlete – and What This Means for Your SQL Server

By

Do you know if your SQL Server is really running at its best? To...

Retro Data 2025 – Slidedeck

By

You can find the slides of my session on the €100 DWH in Azure...

The Book of Redgate: We Value Teams

By

This value is something that I still hear today: our best work is done...

Read the latest Blogs

Forums

Single User SQL Server on Linux

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Single User SQL Server on...

All the Costs of Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item All the Costs of Downtime

How Well Does the MSSQL Extension in VSCode Work?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Well Does the MSSQL...

Visit the forum

Question of the Day

Single User SQL Server on Linux

How can I start SQL Server on Linux in single-user mode to restore the master database?

See possible answers