#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

384 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

2,888 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

437 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,010 reads

Blogs

SQL Prompt and SSMS 18.5

By

I downloaded SSMS 18.5, as there were a lot of fixes in here and...

Jupyter Book Challenges in ADS

By

I was excited to try the Jupyter Book feature in the March Azure Data...

Join me (virtually) in Adelaide!

By

I will be presenting a session to the Adelaide SQL Server User Group on...

Read the latest Blogs

Forums

Always on Availability Groups

By shamantha4

Can i configure a 2 Node AG Availability group in the same data(local site) ...

DB mail issue

By ramyours2003

We received error when testing the DBmail The mail could not be sent to...

Issue with case statement

By mcfarlandparkway

i have a table A where the data looks like ID        Name      Phone            CODE...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

ADF Triggers

See possible answers