Feeds:
Posts
Comments

Posts Tagged ‘SQL Transactions’

SQL SERVER – TRANSACTION, DML and Schema Locks

Posted in Pinal Dave, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on June 21, 2010 | 10 Comments »

Today we will be going over a simple but interesting concept. Many a time, I have come across the lack of understanding on how the transactions work in SQL Server. Today we will go over a small but interesting observation. One of my clients had recently invited me to help them out with an interview [...]

Read Full Post »

SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON – A Transactional Behavior

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on January 6, 2010 | 12 Comments »

Earlier, I had written on SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON, and I received a comment regarding when this option can be useful. On the same day, I met Jacob Sebastian—my close friend and SQL Server MVP, I discussed this question with him. During our discussion, we came up with [...]

Read Full Post »

SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction

Posted in Best Practices, Database, Pinal Dave, SQL, SQL Authority, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on December 28, 2009 | 27 Comments »

Few days ago I wrote an article on the myth of table variable stored in the memory—it was very well received by the community. Read complete article here: SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth. Today, I am going to write an article which follows the same series; [...]

Read Full Post »

SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions

Posted in Pinal Dave, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on April 11, 2009 | 2 Comments »

This post is about a riveting observation I made a few days back. While playing with transactions I came across two DMVs  that are associated with Transactions. 1) sys.dm_tran_active_transactions – Returns information about transactions for the instance of SQL Server. 2) sys.dm_tran_current_transaction – Returns a single row that displays the state information of the transaction [...]

Read Full Post »

SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on August 18, 2008 | 19 Comments »

Loyal reader of this blog and “Great SQL Expert” Imran Mohammed always have good attitude towards any problem. Many times his answers very interesting to read and details are very accurate. I came across his two interesting comment on this blog and I would like to share this all of you. Priyank asked following question. [...]

Read Full Post »

Older Posts »