Monthly Archives: January 2014
-
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 -
The “most_recent_sql_handle” column
1January 22, 2014 by Kenneth Fisher
While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in …
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 -
Guid vs Identity columns (Ints)
9January 13, 2014 by Kenneth Fisher
I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary …
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 -
Happy new year!
2January 1, 2014 by Kenneth Fisher
Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had …
Continue reading
