Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact SQL Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

How to Delete Duplicate Rows In Your SQL Server Tables Using the RANK() Function and Common Table Expressions (CTEs) (Video Series)

Video Image Video Category: Design Patterns for Transact-SQL

Skill Level: 500 (Advanced)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
In this three-part series, our SQL author, Scott Whigham, shows you how you can delete duplicate rows in a SQL table using SQL Server 2005/SQL Server 2008.

NOTE: This is an advanced series requiring knowledge of correlated subqueries, HAVING/GROUP BY/AGGs, RANK(), ROW_NUMBER(), derived tables, and recursive Common Table Expressions (CTEs). It depends on you already knowing how to find the duplicates and shows you how you can delete these duplicate rows. For reference, the following videos may help prepare you:

Videos in this Series:


Miscellaneous Bits & Pieces:
Helpful Tools for your SQL Server: Lumigent's Log Explorer is a great tool that allows you to read the transaction log and even undo transactions - very helpful in a crunch
Keyboard Shortcut for SQL Server Management Studio: CTRL+O opens a file
Most SQL Server adminstrators prefer to change the port of a default instance from 1433 to something unused. This prevents hackers and malicious software from connecting to port 1433 and locating a SQL Server. Bottom line: everyone knows that the default SQL Server port is 1433 so, to create a secure server, change the port number

Other Websites We Offer
LearnSqlServer.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
9/8/2008 8:58:58 AM