SQL Script Case When
May 13, 2018
Get Disk Space of a SQL Server

You can quickly check disk space info on a SQL Server host by running the query below. I sometimes find this the quickest way to check available space rather than using PowerShell or the Windows GUI. This SQL Script only work on SQL Server 2008 R2 and above. [crayon-5c913cba05a57195919482/] The query result will be returned […]

SQL Server Script Convert
April 9, 2018
Get Estimated Database Restore Time

If you're backing up or restoring a large database, you can run the script below to find out how long it has left to complete. The performance of a backup or restore will depend on many things such as server hardware, chosen backup options or even a user running queries. The estimated time returned by […]