Scripts

Drop all Connections from a Database

On development servers, at times there is a need for dropping and renaming database(s). These scripts can be used for achieving these tasks. The usp_DropDB script will kill the connections to the database and then drop the database. It takes care of the space in the database name, if any and also makes sure that […]

5 (2)

2001-08-08

3,999 reads

Quickly Enable/Disable Triggers and Constraints

When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]

5 (1)

2001-08-08

2,956 reads

Blogs

Better Productivity: Cycling the Windows Clipboard in Windows 10

By

A quick tip I learned, that has become handy for me. Tl;dr: Try Win+V...

Daily Coping 21 Sep 2020

By

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

Daily Coping 18 Sep 2020

By

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

Read the latest Blogs

Forums

Italian restaurant abu dhabi

By dianarobbert

The food must taste good, giving the pleasure to eat it and must be...

sql server 2016 performance tuning

By rohitkocharda

I have opportunity to tune below monster query. Is there anything right off the...

How Many Distinct Records

By Sergiy

Comments posted to this topic are about the item How Many Distinct Records

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers