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

562 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

The Data platform has evolved – so too must the DBA.

By

This blog post is around the changing landscape of both SQL Server and the...

What does the Machine Learning process look like?

By

This is the second article in the Machine Learning area. I have explained a...

Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions

By

In this article, we will focus on creating a data pipeline to ETL (Extract,...

Read the latest Blogs

Forums

Container Ports

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Container Ports

Receiving timeout errors on SQL2014

By Dhruva_51

Similar to the one mentioned in the below article. We are sql server build...

Continue SQL Server transactional replication with AWS DMS

By tttcoding

Hello, I have a task for which I wasn't able to find much information...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers