Technical Article

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 […]

(3)

You rated this post out of 5. Change rating

2010-04-19 (first published: )

2,234 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCU PANGERAN JAYAKARTA Call CSO; (+62 821°3111°179

By ilmihouse1

Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta Pusat,...

BCA KCP Genteng Kali Hub:Cs.08216977726

By fbmcleaningservice

Whatsapp:08216977726 Jl. Genteng Kali No.89, Genteng, Kec. Genteng, Surabaya, Jawa Timur 60278

BCA KCP Citra Garden II Call CSO; (+62 821°3111°179

By ilmihouse1

Ruko Citra Niaga, Perum. Citra Garden II Blok B No. 1 & 2, Pegadungan,...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers