In this article, we will explore Setting Deadlock Priority to Control the Rolled Back Transaction. Let us explore more in this blog post.
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
SQL SERVER – CREATE Statement in TRANSACTION
Recently my client of Comprehensive Database Performance Health Check asked me if we can use the CREATE statement in the TRANSACTION or not.
Nested Transactions are Myth – SQL in Sixty Seconds #125
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.
SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session
In this blog, I would share my understanding and the solution of Linked Server Error – Msg 3910 – Transaction context in use by another session.
How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262
Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.