<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
T-SQL Aids
,
Index Management
,
Maintenance and Management
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(15)
TSQL
(6)
sys.dm_db_partition_stats
(4)
Index Usage
(1)
SQLInsider Scripts
(9)
T-SQL
(6)
Backup / Restore
(2)
Missing Indexes
(1)
Administration
(6)
Tuning
(6)
Lock and Connection Management
(2)
Performance Tuning
(1)
Indexes
(6)
Utility
(6)
Performance
(2)
Replication
(1)
Indexing
(6)
Crosstab
(4)
Data Warehouse
(1)
Selectivity
(1)
Maintenance
(6)
FOR XML PATH
(4)
Duplicate Indexes
(1)
sys.dm_db_index_usage_stats
(1)
SQL 2005
(6)
List Indexes
(4)
Index Tuning
(1)
sys.dm_db_missing_index_details
(1)
SQL Server 2005
(6)
pivot
(4)
Search for
any
content tagged
T-SQL Aids & Index Management & Maintenance and Management
Add a script
Items 1 to 20 of 22
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:
|
Discuss
|
Briefcase
|
1,788 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
|
326 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
|
311 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
|
609 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
|
737 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:
|
Discuss
|
Briefcase
|
611 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,811 reads
Drop a Column and its Constraints and Indexes
Read more...
By
Andy Brown
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
958 reads
Stored Proc to List Columns for a Primary Key
Read more...
By
Charles Hawkins
2006/09/14
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
409 reads
Replication PreScreen for proper Primary Keys
Read more...
By
Adam Jorgensen
2005/08/03
|
Category:
Replication
Rating:
|
Discuss
|
Briefcase
|
180 reads
Move a table between filegroups
Read more...
By
Omri Bahat
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
495 reads
Execute SQL-DMO Database method on all databases
Read more...
By
Roy Ashbrook
2005/04/27
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
351 reads
Retrieve Index Information For All Tables - V2
Read more...
By
Nicholas Cain
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
616 reads
Full server documentation
Read more...
By
ceapinto
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,127 reads
To get Table and column name for Primary Keys.
Read more...
By
Mohit Nayyar
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
586 reads
Find Duplicate Indexes (Updated)
Read more...
By
G.R.Preethiviraj Kulasingham
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
588 reads
Find duplicate indexes
Read more...
By
Clinton Herring
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
522 reads
For SQL 2000.Scan all indexes for fragmentation
Read more...
By
Rodrigo Acosta
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,085 reads
Show valuable info from sysindexes
Read more...
By
Rodrigo Acosta
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,666 reads
Summary of how to manage FULL TEXT indexing in TSQ
Read more...
By
iecdba
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
372 reads
Items 1 to 20 of 22
Next 20 >>
Most popular
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:
|
Discuss
|
Briefcase
|
1,788 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,811 reads
Drop a Column and its Constraints and Indexes
Read more...
By
Andy Brown
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
958 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
