Rahul Sharma

Rahul Sharma is a senior database administrator for Manhattan Associates, Inc., and a columnist for databasejournal.com, dbazine.com and SQLServerCentral.com. He has a bachelors and a masters degree in engineering and has been working with Microsoft SQL Server since the release of SQL Server 6.5 and is currently working with both SQL Server 2000 and Oracle 9i. He is a Microsoft Certified Professional with more than six years of experience in database development and administration. He is published (Publishers: Addison Wesley) and his book's title is: Microsoft SQL Server 2000: A Guide to Enhancements and New Features (ISBN: 0201752832).

Technical Article

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)

You rated this post out of 5. Change rating

2001-08-08

5,203 reads

Blogs

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Identify the (Top 20) most expensive queries across your SQL Server using Query Store

By

Script to identify the most expensive queries on your database server using the Query...

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Read the latest Blogs

Forums

TOP with Order By alternative, performance results look mixed

By MMartin1

Hi I have a situation where I am testing two versions of the same...

Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019

By ericwenger1

I'm looking for best practice here and these are Azure VMs by the way....

Azure availability groups requirements question

By Brandie Tarvin

Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers