Tag Archives: microsoft sql server
-
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)
11January 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?
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 -
SSMS Shortcuts and more
Leave a commentDecember 23, 2013 by Kenneth Fisher
I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs. …
Continue reading -
Transactions: Rolling back part of a transaction.
1December 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
5December 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 -
T-SQL Tuesday #49: Wait for it
3December 10, 2013 by Kenneth Fisher
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. …
Continue reading
SQL Studies 