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,887 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,947 reads

Blogs

Using WAITFOR to Test Slow Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Power BI Monthly Digest – May 2020

By

This month we will likely have two releases of the Power BI Desktop. In...

Three big reasons T-SQL still beats the GUI – a MinionWare snippet

By

We like code better than mouse clicks for three basic reasons: T-SQL lets you...

Read the latest Blogs

Forums

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Inlining Scalar UDFs

By Greg Larsen

Comments posted to this topic are about the item Inlining Scalar UDFs

Question About Microsoft Data Migration and the MAP

By imani_technology

Hi, has anyone ever transformed the raw output generated by Microsoft Assessment and Planning...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers