Forcibly Shrink the Transaction Log in All DBs
For lazy folks who want to use 'sp_force_shrink_log' in all dbs. This script depends on 'sp_force_shrink_log' already existing.
2002-08-20
977 reads
Scripts
SP to display locking users in tree format
This SP will give a listing of users blocking and being blocked in a tree formation (similar to explorer tree list). It uses a User defined function that recurses through the locking information gathered from sysprocesses. The listing only shows the Hostname (username) and the SPID.First create the User Defined Function (Part One) then create […]
2002-08-19
2,161 reads
Compare the data of 2 Tables (Updated)
The SP compares the data in 2 tables and reports the different data. Tables could be from different servers, different databases or different schemas. This accepts 7 parameters 1, 2: Name of the 2 tables 3 : List only the differences 4. : Compare only the structure 5. : Check timestamp fields too 6. : […]
2002-08-17
1,399 reads
Constraint Generator
This script can be used for generating the sql script for the constraints available on a particular table. There is a provision to generate script if the specified field(s) are part of the constraint.While specifing the field name , delimit them with ';'. Usage is ;Use pubs-- for generating the script for the tableexec Pre_Porting […]
2002-08-16
449 reads
Script to create a standby database server(new).
New feature to relocate files on the secondary server has been added to this script. If you don't need this feature please use my other script that is posted on this website.Run this script on a secondary SQL Server to replicate the data of all the user databases from the primary server every 15 minutes. […]
2002-08-09
313 reads
Script to montior ErrorLogs every 3 hours.
This script monitors your errorlogs every 3 hours for the past 3 hours. It notifies you by email for all types of errors and by pager for all critical errors with severity type > 16. Saves lot of time when you have to monitor several servers every day 24x7. Run this script on a dedicated […]
2002-08-09
1,219 reads
Comparing Contents of 2 tables in T-SQL
How can you compare two tables -- say, table A and table B and determine if their content is the same? Assuming that A and B have same structure, here's how:First, from set theory, recall that: If ((|A| = |B|) && |A U B| = |A|)) ====>>> A = B |A| = NUMBER of rows […]
2002-08-07
1,501 reads
Using a MEMORY table as an array
I liked the script of using a table as an array. But Didn't liked the cursor in it so I rewrote the script so that it uses a memory table.I tested it in the Query analyzer and this one is indeed faster. So all the people out there yelling that a memory table is faster […]
2002-08-07
1,263 reads
Smart Index Manipulation system
We are constantly having to drop indexesfrom tables while repopulating the datain the table. We then have to rebuild the indexes as they were before dropping them.This requires writing a custom drop and recreate index script for each unique situation. If we tryto write scripts ahead of time as soon as the indexing schemechanges on […]
2002-08-06
974 reads
Change DTS package owner
There is a un-documented stored procedure in msdb called sp_reassign_dtspackageowner. Unfortunately, this requires a package name and will only work on one at a time. If one developer is taking over for another, it may be helpful to change all of Bob's dts packages over to Jim. The following procedure will do just that.Not sure […]
2002-08-05
469 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers