2016-11-30 (first published: 2016-11-22)
701 reads
2016-11-30 (first published: 2016-11-22)
701 reads
2016-11-29 (first published: 2015-03-30)
3,731 reads
If you have Always On and need to stop running database backups to the stand by server, use the script.
2016-11-21 (first published: 2016-11-01)
224 reads
2016-10-28 (first published: 2016-10-05)
11,147 reads
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
3,589 reads
2016-10-20 (first published: 2015-05-15)
1,498 reads
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2016-10-18 (first published: 2015-06-01)
1,767 reads
DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.
2016-10-11 (first published: 2016-09-22)
784 reads
If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.
2016-10-10 (first published: 2016-09-26)
481 reads
If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.
2016-10-06 (first published: 2016-09-20)
844 reads
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item SQL Server 2019 PMEM
Comments posted to this topic are about the item Query Optimizer Suggests Wrong Index...