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,355 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
590 reads
At best these phantom backups cause undue headache in troubleshooting. At worst, they make...
In April, I said I was going to start learning Jupyter Notebooks. It’s November....
I’m a creature of habit. I have my routine when I get to my...
Comments posted to this topic are about the item Numeric and Decimal, which is...
How can I convert this into a Case statement so that the query is...
Comments posted to this topic are about the item The Conference Springboard
Ask SSC