<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><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
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tags
Index Management
,
Maintenance and Management
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(29)
SQL 2005
(6)
List Indexes
(4)
Index Tuning
(1)
T-SQL Aids
(22)
TSQL
(6)
Lock and Connection Management
(4)
Index Usage
(1)
SQLInsider Scripts
(16)
T-SQL
(6)
pivot
(4)
Missing Indexes
(1)
Backup / Restore
(8)
Tuning
(6)
sys.dm_db_partition_stats
(4)
Performance Tuning
(1)
Administration
(7)
Utility
(6)
Replication
(3)
Selectivity
(1)
SQL Server 2005
(7)
Crosstab
(4)
Mail
(2)
SQL Server 2008
(1)
Indexes
(6)
Data Warehouse
(4)
Performance
(2)
sys.dm_db_index_usage_stats
(1)
Indexing
(6)
FOR XML PATH
(4)
Duplicate Indexes
(1)
sys.dm_db_missing_index_details
(1)
Maintenance
(6)
Search for
any
content tagged
Index Management & Maintenance and Management
Add a script
Items 1 to 20 of 54
Next 20 >>
The Ultimate Missing Index Finder
Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
Read more...
By
Jesse Roberge
2008/10/06
|
Source:
SQLServerCentral.com
|
Category:
Index Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
346 reads
The Ultimate Prospective-Index Column(s) Selectivity Analyzer
Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.
Read more...
By
Jesse Roberge
2008/10/24
|
Source:
SQLServerCentral.com
|
Category:
Index Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
100 reads
The Ultimate Duplicate Index Finder
Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.
Read more...
By
Jesse Roberge
2008/10/17
|
Source:
SQLServerCentral.com
|
Category:
Index Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
107 reads
The Ultimate Index Usage Reporter
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
Read more...
By
Jesse Roberge
2008/10/13
|
Source:
SQLServerCentral.com
|
Category:
Index Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
199 reads
The Ultimate Index Lister (Non-Pivoted)
Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.
Read more...
By
Jesse Roberge
2008/10/07
|
Source:
SQLServerCentral.com
|
Category:
Index Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
92 reads
The Ultimate Index Lister (Pivoted)
Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.
Read more...
By
Jesse Roberge
2008/10/09
|
Source:
SQLServerCentral.com
|
Category:
Index Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
89 reads
SQL Server 2005 & 2008 - Backup, Integrity Check & Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008.
Read more...
By
Ola Hallengren
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
6,603 reads
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
4,399 reads
SQL Server 2005: Script all Indexes
Read more...
By
Oxygen
2007/03/27
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,530 reads
SQL Server 2005: Script all Primary Keys
Read more...
By
Oxygen
2007/03/28
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
545 reads
Drop a Column and its Constraints and Indexes
Read more...
By
Andy Brown
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
862 reads
Find possible missing foreign key relationships
Read more...
By
Patricia Schiefelbein
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
282 reads
Remove index fragmentation
Read more...
By
Andrew J. Esser
2007/07/20
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
902 reads
Update statistics for all tables in any DB
Read more...
By
SanjayAttray
2006/12/22
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
1,553 reads
Get All Foreign Key names and Tables referenced
Read more...
By
vishy
2007/07/09
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
147 reads
List all indexes with keys, description and size
Read more...
By
Eugene Bereznuk
2007/07/03
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
1,297 reads
Stored Proc to List Columns for a Primary Key
Read more...
By
Charles Hawkins
2006/09/14
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
392 reads
Function to return the SQL Version Number
Read more...
By
Andy Brown
0001/01/01
|
Category:
Replication
Rating:
|
Discuss
|
Briefcase
|
583 reads
Function to return the SQL Build Number
Read more...
By
Andy Brown
0001/01/01
|
Category:
Replication
Rating:
|
Discuss
|
Briefcase
|
475 reads
Improved Move indexes to new file group
Read more...
By
Adam Jorgensen
2006/03/22
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
667 reads
Items 1 to 20 of 54
Next 20 >>
Most popular
SQL Server 2005 & 2008 - Backup, Integrity Check & Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008.
Read more...
By
Ola Hallengren
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
6,603 reads
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
4,399 reads
Update statistics for all tables in any DB
Read more...
By
SanjayAttray
2006/12/22
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
1,553 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
