The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.
2021-07-12 (first published: 2021-07-06)
518 reads
2021-04-27
775 reads
2021-04-26
461 reads
Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently. Note. This won't show correct information on Linux instances and if you use mounting points in Windows.
2021-04-23 (first published: 2021-04-19)
423 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)
3,608 reads
2020-07-24 (first published: 2018-12-27)
4,223 reads
2020-07-07
550 reads
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-06-25 (first published: 2018-06-05)
1,805 reads
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.
2020-06-16 (first published: 2020-06-12)
1,017 reads
2019-09-26
569 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
This post is part of the series I kicked off here. You can read...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I can't remember ever trying this before, but I have need to do it...
I just installed a new instance of SQL Developer Edition - All my apps...
Ask SSC