Eliminate Duplicates

This will find and delete all duplicate rows. You can refine the granularity of uniqueness by including more columns than just the Primary Key. If you are picky about which rows you want to delete, don't use this. Instead use the 'Find Duplicates' script I just submitted and then delete manually.

2002-05-24

1,081 reads

Find Duplicates

Find duplicates in any table, and report the number of duplicates. Enter in the table name, and the field or fieldsfor which there should only be one row for each of that field, but you suspect are more. For example, if an employee table has more than one record for an employeethis will find any […]

5 (1)

2002-05-24

571 reads

TableCounts

This script generates a statement that you would then run in the user database to get rowcounts of all tables. The advantages of this approach are you can modify it to get just the tables you want, and the output is easy to read:Table1-------1069Table2------10427

2002-05-24

406 reads

Blogs

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SSL Security Error

By SQLRO

Hello, We are trying to connect to another SQL Server database (2012 build 11.0.7001)...

How often do you apply CU ? (SQL SERVER 2019)

By David95

I upgraded from sql server 2014 to Sql Server 2019 mid of last year...

Stories to Engage Us

By Grant Fritchey

Comments posted to this topic are about the item Stories to Engage Us

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers