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
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
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
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
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
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
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...
Hello Everyone, At work, I've been getting more involved with hosting and database stuff....