Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag duplicates Rss

Search for any content tagged duplicates

   Items 1 to 4 of 4   
 

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.  Read more...
By Mike McQuillan 2016/11/08 | Source: SQLServerCentral.com | Category: over
Rating: |  Discuss |   Briefcase | 3,345 reads

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 2016/07/08 (first published: 2014/06/16) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 11,537 reads

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 2016/07/08 (first published: 2014/06/16) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 11,537 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,309 reads
   Items 1 to 4 of 4