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
958 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;
2019-08-01
958 reads
2019-07-23
10,128 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)
8,090 reads
2020-07-24 (first published: 2018-12-27)
4,650 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,243 reads