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,742 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,429 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
826 reads
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Hi friends, Is it possible to configure ALwaysON with two instances on one node...
I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three...
Hello everyone! We have a small group of users (4) using MS Access 2000...
Ask SSC