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
971 reads
Evgeny Garaev, 2020-06-16 (first published: 2020-06-12)
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.
select (8.0*sum(size))/1024/1024 TotalGB from sys.master_files;
Read 28,985 times
(101 in last 30 days)
2019-08-01
971 reads
2019-07-23
10,451 reads
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)
9,000 reads
2020-07-24 (first published: 2018-12-27)
4,720 reads
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,392 reads
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy