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,861 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,942 reads

Blogs

Code from Redgate Streamed

By

I presented a session today at Redgate Streamed and did a number of demos....

Daily Coping–2 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Learn SSIS and ADF for Free

By

It’s not from SQLServerCentral, though I hope to do more training across the next...

Read the latest Blogs

Forums

https //teespring com/instalift-cream-reviews-uk

By donnahinrichs

<!--more--> Instalift Most women at age 50 and above take care of gain weight...

Job failed

By ramyours2003

We migrated jobs from sql 2012 to sql 2019 , one  of the job...

Nike Air Max 270 React ENG Photon Dust Coming Soon

By stevenrowe98

has just dropped a brand new “Digital Pink” colorway of the Blazer Mid as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers