Tag Archives: transactions
-
Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;
Leave a commentNovember 27, 2019 by Kenneth Fisher
One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of …
Continue reading -
What is a distributed transaction?
1May 28, 2019 by Kenneth Fisher
A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example …
Continue reading -
Blocking and deadlocking on purpose
3July 1, 2015 by Kenneth Fisher
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling …
Continue reading -
Playing with the log – Before the first full backup
1October 29, 2014 by Kenneth Fisher
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
Continue reading -
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 -
Negative session_ids
3January 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?
7January 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