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,689 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,427 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
797 reads
When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...
By todd-32417
With the WordPress 5.8 release, we're starting to introduce features that overall improve your...
This is something that comes up time and time again. A developer or member...
i have a formula that calculates the difference between two dates and tells me...
I trying to figure out what percentage of the total charge for a ME...
I am trying to create groups for each Name and save the max and...
Ask SSC