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 49    Older >>
 

Primary key vs Unique key

By Rabih Karam 2014/10/28 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,103 reads

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100  Read more...
Rating: |  Discuss |   Briefcase | 515 reads

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,281 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,204 reads

Dropping indexes

By Jagadish Punnapu 2014/01/02 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,133 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,574 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,202 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,626 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,477 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,881 reads

Index defaults 2

By Hugo Kornelis 2012/06/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,495 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,553 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,749 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,407 reads

Page split - 2

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

DBCC INDEXDEFRAG

By FOR SQLSERVER 2011/08/02 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,512 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,881 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,129 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,257 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,129 reads
   Items 1 to 20 of 49    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)