Technical Article

Constraint Generator

This script can be used for generating the sql script for the constraints available on a particular table. There is a provision to generate script if the specified field(s) are part of the constraint.While specifing the field name , delimit them with ';'. Usage is ;Use pubs-- for generating the script for the tableexec Pre_Porting […]

2002-08-16

246 reads

Technical Article

Find Duplicate Indexes

This script will be helpful in detecting duplicate indexes created ( on the same set of field(s) ). These would have been created by accident, because of their existence the performance will be affected.

5 (3)

2002-04-16

1,799 reads

Blogs

Daily Coping 26 Jan 2023

By

Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell

By

Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project

By

SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs

Forums

Speakers Are Normal People

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Speakers Are Normal People

Publishing a Public Power BI Report from Google Sheets

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Publishing a Public Power BI...

Automatic Formatting of Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Automatic Formatting of Code

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers