SQL Server Central is supported by Red Gate Software Ltd.
 
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 SQL Server 2005, Administration, Maintenance and Management, T-SQL Aids, Performance Rss

Refine your search with one of the following additional tags (with number of items):

Index Management (2)     TSQL (2)     FOR XML PATH (1)     pivot (1)    
Indexes (2)     T-SQL (2)     Index Tuning (1)     Selectivity (1)    
Indexing (2)     Tuning (2)     Missing Indexes (1)     sys.dm_db_missing_index_details (1)    
Maintenance (2)     Utility (2)     Performance Tuning (1)     sys.dm_db_partition_stats (1)    
SQL 2005 (2)     Crosstab (1)    

Search for any content tagged SQL Server 2005 & Administration & Maintenance and Management & T-SQL Aids & Performance

Add a script

   Items 1 to 2 of 2   
 

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 | 3,046 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: |  Discuss |  Briefcase | 868 reads
   Items 1 to 2 of 2   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use