<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
Indexing
,
Fragmentation
Items 1 to 20 of 20
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
Read more...
By
Grant Fritchey
2013/01/11
|
Source:
SQLServerCentral.com
|
Category:
fragmentation
Rating:
|
Discuss
|
Briefcase
|
2,393 reads
Smart Index Rebuild - All Databases
Rebuilds all indexes from all databases over a specified fragmentation threshold.
Read more...
By
Tim Hollobon
2012/11/08
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,663 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
Read more...
By
MUTHUKKUMARAN KALIYAMOORTHY
2012/09/26
|
Source:
SQLServerCentral.com
|
Category:
automated index defragmentation script
Rating:
|
Discuss
|
Briefcase
|
10,767 reads
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.
Read more...
By
Hakim Ali
2012/05/25
|
Source:
SQLServerCentral.com
|
Category:
fragmentation
Rating:
|
Discuss
|
Briefcase
|
2,133 reads
Index Defragmentation (2005, 2008, 2012)
Complete script for index defragmentation and updating stats
Read more...
By
Gregory Ferdinandsen
2012/01/02
|
Source:
SQLServerCentral.com
|
Category:
fragmentation
Rating:
|
Discuss
|
Briefcase
|
2,412 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
Read more...
By
MUTHUKKUMARAN KALIYAMOORTHY
2012/09/26
|
Source:
SQLServerCentral.com
|
Category:
automated index defragmentation script
Rating:
|
Discuss
|
Briefcase
|
10,767 reads
Index Fragmentation for All Databases
Returns Top 25 fragmented indexes complete with full object name and index name.
Read more...
By
Jon Morisi
2011/04/29
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
6,154 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
Read more...
By
MUTHUKKUMARAN KALIYAMOORTHY
2012/09/26
|
Source:
SQLServerCentral.com
|
Category:
automated index defragmentation script
Rating:
|
Discuss
|
Briefcase
|
10,767 reads
Index Fragmentation for All Databases
Returns Top 25 fragmented indexes complete with full object name and index name.
Read more...
By
Jon Morisi
2011/04/29
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
6,154 reads
Index Defragmentation and update stats
A thorough SP for rebuilding indexes.
Read more...
By
Gregory Ferdinandsen
2011/03/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
3,090 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
Read more...
By
MUTHUKKUMARAN KALIYAMOORTHY
2012/09/26
|
Source:
SQLServerCentral.com
|
Category:
automated index defragmentation script
Rating:
|
Discuss
|
Briefcase
|
10,767 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
Read more...
By
MUTHUKKUMARAN KALIYAMOORTHY
2012/09/26
|
Source:
SQLServerCentral.com
|
Category:
automated index defragmentation script
Rating:
|
Discuss
|
Briefcase
|
10,767 reads
Keep Your SQL Server Indexes Fragmentation Free
Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.
Read more...
By
Additional Articles
2009/09/22
|
Source:
DevX
|
Category:
indexing
Rating:
Rate this
|
Briefcase
|
4,948 reads
Index Fragmentation for All Databases
Returns Top 25 fragmented indexes complete with full object name and index name.
Read more...
By
Jon Morisi
2011/04/29
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
6,154 reads
Reindex SQL Tables
This stored procedure will reindex indexes based on the fragmentation lever.
Read more...
By
Balbir Singh
2009/05/14
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,821 reads
Analyze and Fix Index Fragmentation in SQL Server 2008
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation
Read more...
By
Additional Articles
2008/12/11
|
Source:
SQL Server Performance
|
Category:
fragmentation
Rating:
Rate this
|
Briefcase
|
2,419 reads
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
Read more...
By
Grant Fritchey
2013/01/11
|
Source:
SQLServerCentral.com
|
Category:
fragmentation
Rating:
|
Discuss
|
Briefcase
|
2,393 reads
Predictable Index Fragmentation
This technical article provides an overview of how to produce specific levels of index fragmentation. Useful for creating test plans.
Read more...
By
Craig Outcalt
2008/10/29
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
6,350 reads
Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
Read more...
By
Gaby Abed
2013/05/23
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,965 reads
Check Fragmentation on All Indexes on Database
In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
Read more...
By
Augusto Alfonso
2008/09/03
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
4,185 reads
Items 1 to 20 of 20
Tags
defragment
(2)
maintenance
(2)
rebuild
(2)
administration
(1)
all
(1)
automated index defragmentation script
(1)
custom index defragmentation
(1)
databases
(1)
defragmentation
(1)
frag
(1)
rand()
(1)
rebuild index script
(1)
rebuild indexes
(1)
reindex
(1)
reorganize
(1)
reorganize indexes
(1)
sql server 2005
(1)
sql server 2008
(1)
stats
(1)
testing
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
