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

Content with tag Indexes Rss

   Items 1 to 11 of 11   

Yet another way to defrag indexes

A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.  Read more...
By Gaby Abed 2014/07/25 | Source: | Category: defragmentation
Rating: |  Discuss |   Briefcase | 1,133 reads


By free mascot 2014/03/21 | Category: indexes
Rating: (not yet rated) |  Discuss |   Briefcase | 2,046 reads

List Table Foreign Keys, Primary key and indexes

This procedure let you list [optional] by table: -Foreign keys -Primary key -Indexes   Read more...
By Martin Collazos 2014/02/18 | Source: | Category: foreign key list
Rating: |  Discuss |   Briefcase | 1,736 reads

Find the size of all Indexes in a database

This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.  Read more...
By Bodhisatya Mookherjee 2013/10/15 | Source: | Category: indexes
Rating: |  Discuss |   Briefcase | 1,436 reads

Script out/store all indexes on a server

This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.  Read more...
By MyDoggieJessie 2013/09/03 | Source: | Category: indexes
Rating: |  Discuss |   Briefcase | 1,190 reads

Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table

This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.   Read more...
Rating: |  Discuss |   Briefcase | 5,376 reads

SQL Server: How Important Are Index Statistics

In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.  Read more...
By Additional Articles 2013/07/11 | Source: Database Journal | Category: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,816 reads

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,736 reads

Script to Rebuild/Reorganise Indexes

A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly  Read more...
By Andrew Pruski 2013/02/19 | Source: | Category: indexes
Rating: |  Discuss |   Briefcase | 1,819 reads

Hypothetical Indexes on SQL Server

Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.  Read more...
By Additional Articles 2013/01/22 | Source: SimpleTalk | Category: indexes
Rating:  Rate this |   Briefcase | 3,100 reads
   Items 1 to 11 of 11   
administration (1)    
checksum (1)    
defrag (1)    
defragmentation (1)    
disaster recovery (dr) (1)    
filegroups (1)    
fk (1)    
foreign key (1)    
foreign key list (1)    
hashbytes (1)    
indices (1)    
maintenance (1)    
merge (1)    
pk (1)    
primary key (1)    
size of indexes (1)    
slowly changing facts (1)    
sql server (1)    
sql server 2014 (1)    
t-sql (1)