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,536 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,388 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
605 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
How many times have you been afraid to hear “No”? We have all been...
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
I ran a DBCC on a database and it found some anomalies. Just looking...
Dear Everyone I hope you are all safe in these strange times. I am...
Hi Team, Greetings! I have below table. let table name =Emp I need to...
Ask SSC