While I work on performance tuning most of the time, I do provide consultancy on issues which can be resolved quickly. These are the engagement where I get a lot of content for my blogs as well. Let us learn about the error related to redo log record.
SQL SERVER – How to Identify a DB is Using Cross-Database Transactions?
Recently, when I was at a conference, one of the attendees came to me to ask a question. The conversation was as below for cross-database transactions.
SQL SERVER – Knowing Nested Transactions Behavior with SQL Server
SQL Server is an interesting database system that baffles me every single day that I get to learn something new. This blog has been my way to share these learnings. Every time I write something new, my blog readers have been kind enough in pushing me with interesting comments that…
Read MoreSQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
I recently received a question on my Facebook page- “Pinal, How do I know if there is any open transaction in my database? I recently wanted to restart my server, but my manager asked me to first check if there is any open transaction in database before I restart the…
Read MoreSQL SERVER – TRANSACTION, DML and Schema Locks
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…
Read MoreSQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON – A Transactional Behavior
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…
Read MoreSQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction
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…
Read More