Find duplicates in any table, and report the number of duplicates. Enter in the table name, and the field or fields
for 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 employee
this will find any multiple instances of his emplid.
Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.
2018-05-18 (first published: 2015-10-19)
4,821 reads