This will find and delete all duplicate rows. You can refine the granularity of uniqueness by including more columns than just the Primary Key. If you are picky about which rows you want to delete, don't use this. Instead use the 'Find Duplicates' script I just submitted and then delete manually.
2002-05-24
1,090 reads
Find duplicates in any table, and report the number of duplicates. Enter in the table name, and the field or fieldsfor which there should only be one row for each of that field, but you suspect are more. For example, if an employee table has more than one record for an employeethis will find any […]
2002-05-24
586 reads
This script generates a statement that you would then run in the user database to get rowcounts of all tables. The advantages of this approach are you can modify it to get just the tables you want, and the output is easy to read:Table1-------1069Table2------10427
2002-05-24
415 reads
By DataOnWheels
Had an incredible time at DevUp in St. Louis this weekend! This conference gets...
By Chris Yates
The textile world is undergoing a transformation, one where creativity meets computation, and tradition...
By Brian Kelley
On August 6, 2025, Microsoft announced a vulnerability with hybrid deployments because of a...
Comments posted to this topic are about the item Everyone Wants a Piece of...
Comments posted to this topic are about the item MongoDB and NodeJS in action
Hi we're noticing this 2022 server gets into a funk now and then. Specifically,...
Is it possible to recover data from a non-clustered index on the firstname and lastname columns in case of corruption?