Posted by SQL Enthusiast
Article by our editor
It can useful to periodically check the amount of disk space used by each database on a server. This tip shows how to do this using sp_spaceused system stored procedure and also by querying the sys.databases and sys.master_files system views.
Comments (5) • Read full article »
One thing I like to do occasionally, or when "inheriting" a new SQL server is to check which users have sysadmin privileges. As these users have access to perform any activity in SQL Server it’s important to keep the number of these users to a minimum especially on production systems.
Comments (7) • Read full article »
More SQL questions »