Tags » SQL Index

SQL SERVER - Index Fragmentation Next Steps - Notes from the Field #020

: Indexes are considered as a silver bullet to performance tuning and do amazing job when they are properly created. Just like any other engine they need maintenance and tuning. 502 more words

SQL Authority

Index defragmentation of SQl Index

DECLARE @RowThreshold INT
DECLARE @PercentThreshold DECIMAL(38,10)

/***********************************************************************************************************************************
*************SET PARAMETERS*********************************************************************************************************/

SET @RowThreshold = 100 –Threshold for the number of rows. In the number of rows in the index is less that the threshold… 221 more words