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

Content with tag duplicates Rss

   Items 1 to 5 of 5   
 

Finding and Eliminating Duplicate or Overlapping Indexes

Duplicate & Overlapping Indexes can be a drag on write speed and disk resources. How do we find and eliminate them quickly and effectively?  Read more...
By Edward Pollack 2014/06/16 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,937 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,589 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,589 reads

Duplicate Records using SQLCMD

We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.  Read more...
By Renato Buda 2009/04/06 | Source: SQLServerCentral.com | Category: duplicates
Rating: |  Discuss |   Briefcase | 9,264 reads

How to eliminate duplicate records from a database table?

Accidently, the PK and Identity is removed and there are duplicate records in the table. Now we need to introduce the PK back on MyID by cleaning the database table.  Read more...
By rajeshwari-967105 2009/01/06 | Source: SQLServerCentral.com | Category: duplicates
Rating: |  Discuss |   Briefcase | 2,269 reads
   Items 1 to 5 of 5   
 
Tags
analysis services (ssas) (1)    
breakdown (1)    
details (1)    
index (1)    
indexing (1)    
optimization (1)    
optimize (1)    
performance (1)    
row_number() (1)    
scans (1)    
seeks (1)    
size (1)    
sqlcmd (1)    
stats (1)    
troubleshoot (1)    
unused (1)    
usage (1)