This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status. If you have a situation where single connections are causing a huge blocking chain and you want […]
2003-05-12
2,527 reads
For each user database rebuild indexes, update statistics and shrink. The script will use the system catalog to produce a list of databases. If you want to excluce a database add the excluded db name to the 'not in' list. You can also adjust the target fillfactor.
2003-05-07
1,366 reads
For each user database remove all the freespace and truncate the transaction log. The script will use the system catalog to produce a list of databases. If you want to excluce a database add the excluded db name to the 'not in' list below.
2003-05-07
595 reads
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
By Will Assaf
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...
That aging hippie (he likes Apple products and has a goatee) known as Brent...
Hi, using Merge I can sync table A with Table B at ROW level....
This question is about SQL Server Licencing and licencing for Maximum Virtualisation. I'm curious...
All, I know this topic has been discussed numerous times and I tried all...
Ask SSC