Technical Article

Defragment all table indecies

To help maintain index quality, defragging of any given index is a good thing. This will defrag ALL indecies in the current DB. NOTE: Schedule for off-hours operations. For a massive re-write of indecies, change the remarking on "--IF @indid" lines to use reindex instead of just defragging.

2004-09-21

561 reads

Blogs

Daily Coping 27 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Seeding an Availability Group Replica from Snapshot

By

Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...

Read the latest Blogs

Forums

Sign all stored procedures with a Certificate.

By HanYolo

Hello, My company is going about ever increasing our security on all our Servers/databases....

Upgrading SQL Server 2008 R2 to 2017

By stinger27

Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running...

why I cannot see memory related waits while server is under pressure?

By radekg

Hi, It may be trivial question but I am really confused at this moment....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers