Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
2,628 reads
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
2,628 reads
This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.
2012-04-20
6,402 reads
If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.
2012-03-14
3,229 reads
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation
2008-12-11
2,876 reads
Just a stab at automating index maintainenance in SQL Server 2008
2013-01-11 (first published: 2008-11-07)
2,563 reads
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
2008-10-24
786 reads
2008-05-15 (first published: 2008-02-29)
3,264 reads
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
By kleegeek
I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi All, Could you please let me know what could be the cause of...
Comments posted to this topic are about the item Using mode() in R
We are running SQL Server 2017 (RTM) on Windows. The question came up, if...