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,021 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

191 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

737 reads

Blogs

Restoring Backups from Azure Blob with dbatools

By

Recently I needed to write a PowerShell script that could build a backup set...

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Primary server stay on resolving state- Always ON

By WhiteLotus

Hi All , In my case we’re Looking the cause why in our Always...

fail over database in high availability - Always On

By WhiteLotus

Hi All, Currently we have configured Always on - High Availability in our SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The typo

See possible answers