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,174 reads

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

One of the things I’ve tried hard to do in database development situations if...

The T-SQL Tuesday topic this month comes James Serra. What career risks have you...

We have two "identical" instances of an ASP.NET web service (or so I have...

Comments posted to this topic are about the item OPENQUERY Flexibility

Comments posted to this topic are about the item A Full Shutdown

Which of these are valid OPENQUERY() uses?