May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
deadlock priority

SQL SERVER – Setting Deadlock Priority to Control the Transaction that is Rolled Back

June 29, 2023
Pinal Dave
SQL Performance
Deadlock, SQL Transactions

In this article, we will explore Setting Deadlock Priority to Control the Rolled Back Transaction. Let us explore more in this blog post.

Read More
Transactions and Variables

Transactions and Variables – SQL in Sixty Seconds #150

January 22, 2021
Pinal Dave
SQL Tips and Tricks
SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Transactions

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.

Read More
create statement

SQL SERVER – CREATE Statement in TRANSACTION

November 3, 2020
Pinal Dave
SQL Tips and Tricks
DDL Operation, SQL Scripts, SQL Server, SQL Transactions, Transaction Isolation

Recently my client of Comprehensive Database Performance Health Check asked me if we can use the CREATE statement in the TRANSACTION or not.

Read More
nested transaction

Nested Transactions are Myth – SQL in Sixty Seconds #125

September 25, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Scripts, SQL Server, SQL Transactions

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. 

Read More
open transaction

SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT

September 24, 2020
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL Transactions

How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.

Read More
Transaction context

SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session

February 19, 2020
Pinal Dave
SQL
Linked Server, SQL Error Messages, SQL Scripts, SQL Server, SQL Transactions

In this blog, I would share my understanding and the solution of Linked Server Error – Msg 3910 – Transaction context in use by another session.

Read More
Measure Transactions

How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262

February 2, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Performance, SQL Scripts, SQL Server, SQL Transactions, Windows

Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.

Read More
1 2 3 4 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version