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,394 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
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
C++ is a highly versatile language for developing console applications, batch processing, and performance-critical...
Hi everyone I am using BULK INSERT to load a CSV. I have noticed...
One of our systems contains data for multiple organizations. OrgA should not be able...
We have the following requirement:- Event_Time ...
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers