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
692 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
386 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,118 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
439 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,012 reads
Blogs
Azure SQL Training
By Arun Sirpal
I thought being an Azure Data/Database blogger I would share some amazing content from...
Managing virtual machine drives on ESXi
Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little...
Thinking About the 2021 PASS Summit
By Andy Warren
I know that we don’t yet know how the 2020 Summit will turn out,...
Forums
Career advancement in cloud
I am a SQL server administrator with 5 years of pure DBA experience. I...
Security for 2FA
Comments posted to this topic are about the item Security for 2FA
Basic Git for DBAs: What's a Pull Request?
Comments posted to this topic are about the item Basic Git for DBAs: What's...
Ask SSC