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,523 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,306 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
589 reads
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
This year PASS is trying something new at PASS Summit. There are going to...
One of the most significant and hardest challenges we face as data professionals (or...
I have a table "Mytable" containing a list of IDs. There is a web...
So I have a DW with a table with some pre-aggregated scores (not my...
HI all, About to start this project and would be grateful for any good...
Ask SSC