sp_dbsize
I'm trying to repost the same script submitted on 7/9/2003 which didn't get posted completely for some reason.
2003-07-27
715 reads
#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
4,519 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
446 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,019 reads
Blogs
Daily Coping 23 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Cloud Formations – A New MVP Led Training Initiative
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Call multiple packages based on result set of the query
Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...
LDF is not automatically shrinked with simple recovery mode
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...
Best way to learn T-SQL for MS SQL Server?
Hello Everyone, At work, I've been getting more involved with hosting and database stuff....
Ask SSC