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
4,387 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,835 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,547 reads
They run, they return data. So what? Some SQL queries just waste your time...
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
I have a few tools at my disposal but none of them seems like...
As the title says , I've got a handful of stored procs where the...
What parameters are required for the dab add command in the Data API Builder?
See possible answers