Category Archives: Transactions
-
Transactions: What commands aren’t allowed?
Leave a commentFebruary 5, 2014 by Kenneth Fisher
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put …
Continue reading -
Transactions: Creating a single restore point across multiple databases.
Leave a commentFebruary 3, 2014 by Kenneth Fisher
This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple …
Continue reading -
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
Leave a commentJanuary 29, 2014 by Kenneth Fisher
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
Continue reading -
Negative session_ids
2January 27, 2014 by Kenneth Fisher
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
Continue reading -
Transactions: Who, What and Where
1January 20, 2014 by Kenneth Fisher
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I …
Continue reading -
Transactions: What are they?
4January 8, 2014 by Kenneth Fisher
I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I …
Continue reading -
Transactions: Rolling back a transaction inside a stored procedure.
4January 6, 2014 by Kenneth Fisher
So over the last couple of posts I’ve talked about the fact that the ROLLBACK command will roll back an …
Continue reading -
Transactions: Rolling back part of a transaction.
Leave a commentDecember 19, 2013 by Kenneth Fisher
In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way …
Continue reading -
Transactions: Rolling back a nested transaction
3December 17, 2013 by Kenneth Fisher
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID). …
Continue reading
