I have found this query valuable. Sometimes you need to see just overall consumption without any detailed information. It is also useful in overall trend analysis and disk space planning.
2019-08-01
960 reads
Disk space used by the SQL Server instance
select (8.0*sum(size))/1024/1024 TotalGB from sys.master_files;
Related content
2019-07-23
10,342 reads
Offline R Services installation and patching
The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.
2021-02-12 (first published: 2019-03-28)
8,648 reads
2020-07-24 (first published: 2018-12-27)
4,683 reads
Logshipping to SQL Server on Linux
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-07-09 (first published: 2018-06-05)
2,357 reads