Windows Server 2012 Deduplication – Should you use it with SQL Server Backups?

Fri, 08 Feb 2013 07:00:00 UT

Windows Server 2012 introduces native deduplication functionality. While this is a promising new Windows feature for other file types and characteristics, there are some potential pitfalls that you need to be aware of when it comes to deduplication specifically for SQL Server backup files.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Using Ranking Functions to Deduplicate Data

Tue, 27 Jul 2010 06:00:00 UT

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

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

SQLServerCentral.com Articles tagged Deduplicate

Windows Server 2012 Deduplication – Should you use it with SQL Server Backups?

Using Ranking Functions to Deduplicate Data