Technical Article

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

Technical Article

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

198 reads

Technical Article

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

745 reads

Blogs

Daily Coping 3 Oct 2022

By

Today’s coping tip is to write down three things you appreciate about yourself. I...

Scary Scalar Functions - Part Four: Your Environment

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Read the latest Blogs

Forums

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.

By serverdba

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...

Referencing a SQLCMD variable in a Post Deployment script using SqlPackage

By Weegee71

Ive got a Database project running in JetBrains Rider. The project publishes a DACPAC...

Calling stored procedure to bulk import from SSIS causes access denied

By markdummen

Hi, I'm working on building a data validation engine, which is supposed to check...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers