duplicate data

External Article

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.


6,301 reads


InvalidAbfsRestOperationException in Azure Synapse notebook


Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs


log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers