Andy Riley

Using Ranking Functions to Deduplicate Data

This article from Andrew Riley will show you how you can use the RANK and ROW_NUMBER Ranking Functions to deduplicate data in SQL Server 2005

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(100)

You rated this post out of 5. Change rating

2010-07-27

14,199 reads

If you spend your days tuning queries, managing pipelines, or keeping a production database...

SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...

Probably the best piece of advice I ever received is to take time to...

We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...

Comments posted to this topic are about the item Automating OSM Data Refresh in...

Comments posted to this topic are about the item Database Mail Configuration

If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?