The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.
2017-04-21 (first published: 2017-02-20)
2,083 reads
This report shows all the Indexes on user defined table or view and how effectively they are being used in our project.
2017-04-20 (first published: 2017-04-10)
912 reads
2017-04-17 (first published: 2017-03-27)
558 reads
This stored procedure will truncate a table even when other tables have FKs referencing columns in it. It drops the Fks, truncates the table, re-creates the FKs
2017-04-14 (first published: 2017-03-28)
896 reads
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)
449 reads
2017-03-30 (first published: 2017-03-16)
14,142 reads
The DBA often needs to know when, how much and what kind of database file has changed its size. Also nice to know the amount of free space on the drive where the files are located databases.
2017-03-29 (first published: 2016-01-07)
2,101 reads
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2017-03-28 (first published: 2017-02-21)
1,437 reads
This will Archive and Purge rows from one table to another.
2017-03-27 (first published: 2017-03-17)
821 reads
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,489 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers