Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing 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:
Performance Tip: If your stored procedures use temporary tables or table variables create these as the first line(s) of code in your stored procedure. This helps minimize/prevent recompiles which allows SQL Server to cache the procedure's execution plan for maximum reuse
Keyboard Shortcut for SQL Server Management Studio: Shift+F1 brings up the context-sensitive help in Books Online
osql.exe is a command-line tool that you can use to run your SQL scripts and queries; think of it as the DOS-version of Query Analyzer

Other Websites We Offer
LearnCSharp.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!
 
1/8/2009 2:58:37 PM