Selective Defrag/Reindex and Log

SQL 2000 OnlyThis script will create a stored procedure and a table in the master database. Simply run the stored procedure and supply a database name as a parameter. It will do the following:1. Gather/Log DBCC SHOWCONTIG statistics (pre defrag)2. Defragment all user indexes in the database3. Gather/Log DBCC SHOWCONTIG statistics (post defrag)4. DBCC DBREINDEX […]

5 (3)

2004-11-11 (first published: )

2,193 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Trying to get output of PRINT command after select in Transaction

By boughrogers

Hi I am looking to select the output of the data that I plan...

Patches

By mtz676

How do I generate a report which tells me if my sqlservers are upto...

Use Domain Account for SQL Server service on Linux

By S_DBA

Currently, while installing SQL server we use a local linux account to run the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers