List All Constraints

These four scripts list concise information about all Default, Check, Unique, Foreign Key, and Primary Key constraints for the database in which they are run.  With minor column modifications, they could easily be unioned to provide a single list. The usual caveat applies about directly accessing system tables. They may change in future versions and/or […]

2003-08-14

1,028 reads

Find Duplicate Employees, Customers, Etc.

Customers, employees, etc. come and go.  They get entered multiple times in inconsistent formats in databases.This simple script finds the duplicates across multiple formats and is easily modified as needed.  It's so easy, my grandmother could do it. Oops! No offense Grandma.For very large databases, create and join two temp tables indexed on the namedatetring […]

2003-05-30

193 reads

Find Duplicate Indexes - Episode 1 (The Early SQL Versions)

The excellent script contributed by G.R. Preethiviraj Kulasingham (Preethi) Sri Lanka (contributed 2/20/03, modified 5/22/03) identifies duplicate indexes for the database on which the script is run.  It requires User Defined Functions, a feature restricted to SQL Server 2000.This version achieves similar results without using UDFs or creating any other permanent objects. It therefore works […]

4 (1)

2003-05-28

740 reads

Blogs

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

[Video] Azure SQL Database – Import a Database

By

Quick Video showing you have to use a BACPAC to “import” a database into...

Read the latest Blogs

Forums

How can I exclude records from this table?

By NineIron

How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...

Disable Package Expression

By DinoRS

Hi SSC, I've got 2 Project Variables which I use to control wether a...

Inflow / outflow report per day

By milo1981

Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers