duplicate data

Listing Duplicate Values by Group

  • Article

Without question, one of the most common tasks performed by Database Administrators (DBAs) is identifying and weeding out duplicate values in tables. Despite the inordinate number of queries written by other DBAs to locate duplicate values in their database tables, the real challenge is in locating a useable SQL statement to go by. Rob Gravelle presents a few solutions that will save you some time down the road.

2016-12-15

6,301 reads

Blogs

Cleaning Up Stats Data for Volleyball

By

One of the things I’ve done the last few years is collect statistics as...

Day One, the Journaling App, Joins Automattic

By

We’re excited to welcome Day One to the Automattic team. Day One is a...

Find Queries Using a Key Lookup Operator

By

While teaching about Extended Events and Execution Plans last week, Jason, one of the...

Read the latest Blogs

Forums

Tracking, Privacy, and Lots of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking, Privacy, and Lots of...

Spirit Airlines Corporate Office Headquarters

By romanreignsq1

If you need any help with Spirit Airlines Corporate Office then contact us. Spirit Airlines, the...

Can we use one 'name instance' name to two active/passive cluster

By Harshana-455711

Hi We have SQL server 2014 Active/Passive cluster. And we planned to migrate existing...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers