2 steps:step 1 => create a table in master database called BlockCheckstep 2 => create the stored procedure in master called BLOCK_CHECK @database_name varchar(20)What SP does:- it gets the spid that is blocked + info about it (like what it does at the moment it is blocked)- it gets the spid that acts as a […]
2003-06-05
762 reads
This stored Procedure can be used to force restores the database by killing all the process running over this database.
2003-06-05
444 reads
Retrieve SQL Server port number from registry. Useful for SQL Servers running named instances or non-standard TCP port numbers.
2003-06-04
665 reads
In your tenure as a DBA/developer, you've probably been asked to write dozens of stored procedures similar to this:CREATE PROCEDURE ContactInfo@ContactID intASSELECT c.Name, a.Address, p.PhoneFROM Contact cLEFT JOIN ContactAddress aON c.ContactID = a.ContactIDLEFT JOIN ContactPhone pON c.ContactID = p.ContactIDWHERE c.ContactID = @ContactIDBut there is a more efficient way to write such a query.....particularly if you […]
2003-06-03
1,447 reads
This procedure shows you the MAC number of your Enthernet card in a format exactly the same as when running: ipconfig /all from command shell. Updated thx to Larry A.
2003-05-31
179 reads
Customers, employees, etc. come and go. They get entered multiple times in inconsistent formats in databases.This simple script finds the duplicates across multiple formats and is easily modified as needed. It's so easy, my grandmother could do it. Oops! No offense Grandma.For very large databases, create and join two temp tables indexed on the namedatetring […]
2003-05-30
249 reads
This procedure displays all user-defined datatypes in all databases on a server. Another example of the power of dynamic T-SQL, this procedure dynamically generates SELECT statements for the systypes tables in each database and UNIONs them together so that they display in one recordset.
2003-05-30
194 reads
This script will send a mail whenever it detects a Blocking process. You need SQL Mail configured on this server in order to use or you can specify the pager number @company.comEx:- 1234567789@Skytel.com
2003-05-29
1,887 reads
This procedure reports on table schema changes, any new or deleted tables since the previous run of the stored procedure.It only reports on tables owned by 'dbo'
2003-05-29
481 reads
This script is a fix to the "Script to determine if all chars are same in field"posted by Harvard Kinkead (hneal_98) . That script doesn't handle strings with trailing spaces (e.g. set @repeat = 'bbbb ')It happens because of the nature of Len function. To bypass this limitation my script concatenates one character to tested […]
2003-05-29
120 reads
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Wa:082374977784 Jl. Laksamana Yos Sudarso No.128/4F, 3 Ilir, Kec. Ilir Tim. II, Kota Palembang,...
Wa:083849450961 Jl. Letkol Iskandar No.51-52, 24 Ilir, Kec. Bukit Kecil, Kota Palembang, Sumatera Selatan...
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers