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

   Items 1 to 20 of 47    Older >>
 

Index Utilization Trending

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?  Read more...
By Edward Pollack 2014/05/05 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,066 reads

Reorganize indexes

Generate script to reorganize indexes in a database  Read more...
By Andrés Michaca 2014/05/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,116 reads

Dropping indexes

By Jagadish Punnapu 2014/01/02 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,097 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,561 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,193 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,525 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,450 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,840 reads

Index defaults 2

By Hugo Kornelis 2012/06/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,484 reads

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" . First, in BOL, for "DBCC...  Read more...
By 2012/06/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 6,045 reads

Reduce heap table fragmentation

A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.  Read more...
By James Serra 2011/12/13 | Source: SQLServerCentral.com | Category: defragmentation
Rating: (not yet rated)  Rate this |   Briefcase | 4,708 reads

Are remote databases fragmented? Let's Defrag.

This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.  Read more...
By Kimberly Killian 2011/09/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,405 reads

Page split - 2

By bitbucket-25253 2011/08/08 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,314 reads

DBCC INDEXDEFRAG

By FOR SQLSERVER 2011/08/02 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,504 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,840 reads

Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude  Read more...
By Rabie Harriga 2011/03/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,117 reads

Index Defragmentation and update stats

A thorough SP for rebuilding indexes.  Read more...
By Gregory Ferdinandsen 2011/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,242 reads

Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude  Read more...
By Rabie Harriga 2011/03/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,117 reads

Moving Indexes with Powershell and SMO

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.  Read more...
By Zach Mattson 2010/09/30 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 3,996 reads
   Items 1 to 20 of 47    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)    
missing indexes (2)    
monitoring (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)    
dynamic management views (1)    
english query (1)    
foreign keys (fk) (1)    
fragmentation (1)    
heap (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)