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
3,333 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,559 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
1,138 reads
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Hi all! AWS has a good example of how to manipulate the requested objects...
Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...
Hi folks, I have a single Postgres instance on RDS that in the past...
Ask SSC