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,115 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)
920 reads
2017-04-17 (first published: 2017-03-27)
569 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)
919 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)
462 reads
2017-03-30 (first published: 2017-03-16)
14,229 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,106 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,449 reads
This will Archive and Purge rows from one table to another.
2017-03-27 (first published: 2017-03-17)
833 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,531 reads
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Palantir is an American software platform that brings together business data from different sources...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Rk. Gajah Mada, Jl. Gajah Mada No.12, Krajan, Kepatihan, Kec. Ponorogo, Kabupaten Ponorogo,...
WhatsApp:0817819444 Jl. Mayor Abdurahman No.181-183, Kotakaler, Kec. Sumedang Utara, Kabupaten Sumedang, Jawa Barat 45322
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers