Tag: sql

Cleaning Up Bad SQL Data: Find and Delete Duplicate Records The Right Way

Find duplicate data in a production SQL table? Follow this pragmatic, real-world guide to safely find and delete those duplicate rows using a Common Table Expression (CTE), and learn how to prevent it from ever happening again with a unique constraint.

Paging Data in SQL Server 2000

Select Query: Retrieve Fixed Number of Rows Part 2

Select Query: Retrieve Fixed Number of Rows