Technical Article

Eliminate Duplicates

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,084 reads

Technical Article

Find Duplicates

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 […]

5 (1)

2002-05-24

572 reads

Technical Article

TableCounts

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

407 reads

Blogs

Daily Coping 30 Nov 2022

By

Today’s coping tip is to learn a new skill from a friend or share...

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports

By

Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Read the latest Blogs

Forums

Designing Database from a piece of paper

By ciss1

Greetings experts, Hopefully, this is the forum for my question. I am trying to...

Sum up different dates

By pelusch

Hi guys To the table below - I want to sum up the amount...

Error: Column names in each view or function must be unique

By carlton 84646

I am getting the error: Column names in each view or function must be...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers