duplicate data

Technical 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2016-12-15

6,301 reads

Blogs

The Book of Redgate: Fun with Images

By

We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...

Why companies use Palantir and how we help implement it in the Czech Republic

By

Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...

Why companies use Palantir and how we help implement it in the Czech Republic

By

Palantir is an American software platform that brings together business data from different sources...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Alamat BCA KCP Kota Baru Hub/Wa. 0817-819-444

By Halo_BCA

WhatsApp:0817819444 Jl. Prof Doktor Mohammad Yamin, Kota Baru, Kec. Pontianak Sel., Kota Pontianak, Kalimantan...

Alamat BCA KCP Sampit Hub/Wa. 0817-819-444

By layanan 24jam BCA

WhatsApp:0817819444 Jl. A. Yani No. 38 B Sampit RT 25/RW XI Sampit Kelurahan Mentawa...

Visit the forum

Question of the Day

SQL Server Audit Failures

If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?

See possible answers