Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags administration, indexing Rss

<< Newer    Items 21 to 40 of 45    Older >>
 

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,718 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,981 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,718 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,981 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,296 reads

The Ultimate Dupe Finder & Performance Test Parameter Set Researcher

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!  Read more...
By Jesse Roberge 2009/05/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 862 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,182 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,052 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 | 2,943 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,392 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,396 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,547 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 | 18,296 reads

usp_IndexesUnused - SQL 2k5

Checks index usage  Read more...
By Pedro Lopes MS 2008/06/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,081 reads

2005 unused indexes

Shows unused indexes compared to nr of modifications  Read more...
By Wilfred van Dijk 2007/12/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,615 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,296 reads

Index related DMVs and DMFs - sys.dm_db_index_usage_stats

Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats  Read more...
By Additional Articles 2007/11/12 | Source: SQL Server Performance | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 2,530 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,296 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,801 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,204 reads
<< Newer    Items 21 to 40 of 45    Older >>
 
Tags
performance tuning (13)    
t-sql (13)    
sql server 2005 (12)    
maintenance and management (10)    
maintenance (9)    
utility (9)    
sql server 7 (7)    
configuring (5)    
list indexes (5)    
miscellaneous (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
backup / restore (4)    
crosstab (4)    
for xml path (4)    
dts (2)    
installation (2)    
security (2)    
stored procedures (2)    
triggers (2)    
tuning (2)    
user defined function (udf) (2)    
basics (1)    
blogs (1)    
database design (1)    
defragmentation (1)    
distributed queries (1)    
dmv (1)    
duplicate indexes (1)    
english query (1)    
foreign keys (fk) (1)    
fragmentation (1)    
heap (1)    
missing indexes (1)    
monitoring (1)    
openxml (1)    
powershell (1)    
programming (1)    
rebuild (1)    
reindex (1)    
reorganize indexes (1)    
replication (1)    
search (1)    
selectivity (1)    
smo (1)    
strategies (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
tables (1)    
updategrams (1)    
xml (1)    
xsl (1)