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

Content with tags SQL Server 2005, Indexing Rss

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

Indexes in SQL Server 2005

By Suresh Theyyath 2010/01/19 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,994 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,311 reads

SQL Server 2005 Index Best Practices

In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.  Read more...
By Additional Articles 2009/10/09 | Source: MSSQLTips.com | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 6,819 reads

Table Index Store and Create

Query to save all index metadata  Read more...
By Jorge Novo-@ETLDEVDBA 2009/07/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 868 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 | 872 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,214 reads

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,484 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,069 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,993 reads

disable/enable indexes for table

This procedure disables or rebuilds indexes for a given tablename  Read more...
By Wilfred van Dijk 2008/10/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,383 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,513 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,415 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,580 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,713 reads

Checking fragmented indexes

A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.  Read more...
By Gaby Abed 2008/09/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,210 reads

Missing Indexes in SQL Server 2005

Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.  Read more...
By Ranga Narasimhan 2010/07/23 (first published: 2008/09/16) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 31,868 reads

2005 unused indexes v3

shows index usage.   Read more...
By Wilfred van Dijk 2008/09/05 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 1,152 reads

Disabling Indexes

Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index.  Read more...
By Andy Warren 2008/07/22 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 10,515 reads

Index Fragmentation

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.  Read more...
By Sergio Govoni 2011/10/21 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,168 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,093 reads
<< Newer    Items 21 to 40 of 52    Older >>
 
Tags
administration (12)    
maintenance (11)    
performance tuning (10)    
t-sql (10)    
maintenance and management (9)    
utility (9)    
list indexes (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
crosstab (4)    
for xml path (4)    
sql server 2008 (2)    
sql server 7 (2)    
backup (1)    
defragment (1)    
dm_db_index_physical_stats (1)    
dmv (1)    
duplicate indexes (1)    
foreign keys (fk) (1)    
fragmentation (1)    
integrity check (1)    
management (1)    
metadata (1)    
missing indexes (1)    
search (1)    
selectivity (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 2014 (1)    
statistics (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sysobjects (1)    
tables (1)