<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>
Scripts with tag
Fragmentation
Search for
any
content tagged
fragmentation
Add a script
Items 1 to 14 of 14
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,658 reads
SQL Server Index Defragmentation (Updated)
Defrags all indexes in select databases in 2005, 2008, and 2012.
Read more...
By
Gregory Ferdinandsen
2012/09/21
|
Source:
SQLServerCentral.com
|
Category:
admin
Rating:
|
Discuss
|
Briefcase
|
1,687 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,132 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,411 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,085 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,758 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,151 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
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,392 reads
Are disk volumes fragmented on server? Does it require to be defragged
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
Read more...
By
Bhavesh-257515
2013/05/21
|
Source:
SQLServerCentral.com
|
Category:
fragmentation
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
675 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/21
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,964 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
INDEX DEFRAG on SQL SERVER 2005
Defrag all indexes in a database for SQL Server 2005
Read more...
By
Scott Dexter
2008/08/05
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
3,356 reads
SQL Server 2008 index fragmentation
Script to see how fragmented the indexes are.
Read more...
By
BarryK
2008/05/15
|
Source:
SQLServerCentral.com
|
Category:
fragmentation
Rating:
|
Discuss
|
Briefcase
|
2,807 reads
Items 1 to 14 of 14
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
