#sp_shrinkdata

Unlike shrinking transaction log, shrinking a data file seems to be tough. A lot of people complained about the "shrink database" option in EM not working, or DBCC SHRINKDATABASE not working, or DBCC SHRINKFILE not working. I have found that a data file will eventually shrink given enough try, time and patience. I've put everything […]

2003-01-14

391 reads

sp_kill

This stored proc has helped me a lot when I needed to restore db, reconfigure replication, and do other database jobs. SQL server KILL command can only act on a single spid. This sp compiles KILL commands in a cursor to kill a group of spids based on database name, login name, host machine name […]

2002-11-11

3,915 reads

sp_checksqlversion

How many times have you seen @@version return a number but failed to interpret what service pack it is? Although SQL 2000 gives a gift (SERVERPROPERTY) of querying a readable value, my script will remedy the puzzle and show more parameters such as CPU speed, memory, windows version, and installation date. The limitations are:1. MSDE […]

2002-10-16

444 reads

sp_checksize

This stored procedure checks the sizes of one or all databases (including total data, total log, data used/free, data used/free percentage, log used/free, log used/free percentage). If a database name is provided, it will only check the given db. If no parameters provided, all dbs will be checked and the total size of all dbs […]

2002-10-01

1,017 reads

Blogs

The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It

By

Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!

The Post Pandemic Office Experience

By

I traveled to Pasadena, CA this week to work with a few other Redgaters...

Connecting to Azure Blobs in Power BI

By

The step-by-step process below walks through connecting to data housed in Azure Blob Storage...

Read the latest Blogs

Forums

Get the last day of the year based on a date range

By dqurve

I am trying to get the last day of the year from a date...

Put two queries together

By stephen.aa

Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...

Excel Formula to create SQL Script for a Values Table

By allinadazework

Comments posted to this topic are about the item Excel Formula to create SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers