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
973 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
973 reads
2019-07-23
10,478 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,104 reads
2020-07-24 (first published: 2018-12-27)
4,729 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,399 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