Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Content with tags
Maintenance and Management
,
T-SQL
,
Indexing
Items 1 to 20 of 31
Older >>
Get all user def table info
Get space for all user defined table information like size and row counts.
Read more...
By
Mohit Nayyar
2013/12/27
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
7,387 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
2013/10/02
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
3,597 reads
The Ultimate Index Width Stats Reporter
Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.
Read more...
By
Jesse Roberge
2013/07/26
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,255 reads
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
2013/01/07
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
19,109 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
2012/12/27
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
7,643 reads
Get all user def table info
Get space for all user defined table information like size and row counts.
Read more...
By
Mohit Nayyar
2013/12/27
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
7,387 reads
The Ultimate Index-Less Foreign-Key Finder
Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.
Read more...
By
Jesse Roberge
2009/10/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,356 reads
The Ultimate Index Width Stats Reporter
Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.
Read more...
By
Jesse Roberge
2013/07/26
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,255 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:
indexing
Rating:
|
Discuss
|
Briefcase
|
2,083 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:
indexing
Rating:
|
Discuss
|
Briefcase
|
3,033 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
2012/12/27
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
7,643 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:
indexing
Rating:
|
Discuss
|
Briefcase
|
2,435 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
2013/10/02
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
3,597 reads
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
2013/01/07
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
19,109 reads
Get all user def table info
Get space for all user defined table information like size and row counts.
Read more...
By
Mohit Nayyar
2013/12/27
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
7,387 reads
Drop a Column and its Constraints and Indexes
Read more...
By
Andy B.
2007/01/24
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,327 reads
Drop a Column and its Constraints and Indexes
Read more...
By
Andy B.
2007/01/24
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,327 reads
Stored Proc to List Columns for a Primary Key
Read more...
By
Charles Hawkins
2006/09/14
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
642 reads
Replication PreScreen for proper Primary Keys
Read more...
By
Adam Jorgensen
2005/08/03
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
353 reads
Move a table between filegroups
Read more...
By
Omri Bahat-228920
2005/06/16
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
989 reads
Items 1 to 20 of 31
Older >>
Tags
miscellaneous
(15)
sqlinsider scripts
(9)
administration
(8)
performance tuning
(8)
sql server 2005
(8)
utility
(8)
maintenance
(7)
list indexes
(5)
pivot
(5)
sys.dm_db_partition_stats
(5)
crosstab
(4)
for xml path
(4)
backup and restore
(2)
lock and connection management
(2)
data warehousing
(1)
duplicate indexes
(1)
foreign keys (fk)
(1)
missing indexes
(1)
replication
(1)
search
(1)
selectivity
(1)
sys.dm_db_index_usage_stats
(1)
sys.dm_db_missing_index_details
(1)
tables
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.