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,080 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

569 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

405 reads

Blogs

T-SQL Tuesday #125 – Unit testing databases – we need to do this!!

By

Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

T-SQL Tuesday Live–7 Apr 2020

By

Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Dial sbcglobal helpline for Customer Service

By vancevanse0

SBCGlobal Email Settings: If you are going to use Sbcglobal for your email applications...

How not to have sql to restart on the same node but failover on 1st failure in a

By SQLRocker

Hi, By default sql tries to restart on the same node in case of...

Do I need to update statistics after compressing table?

By VoldemarG

I page-compressed a table with one Clustered and 4 non-clustered indexes, 5 million rows....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers