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

566 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

DBA Myths: The system sessions are the ones with a session_id 50 or less

By

Anecdotally any session_id that’s 50 or less is going to be a system session...

SQL Undercover TV – Encrypting SQL Backups

By

In this episode, David looks at how we can encrypt our SQL Server backup...

Using volumes in SQL Server 2019 non-root containers

By

I’ve seen a few people online asking how to use docker named volumes with...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Maintenance Window for SQL Server Critical Alerts

By WebTechie

Hello, We had some sql server have issues on some production servers.  We actually...

Capturing all Error messages caused by SQL Server code

By Lonely Rogue

Hello - The ERROR_MESSAGE() is capturing only the last message in the error stack...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers