Category Archives: Microsoft SQL Server
-
Getting a query plan
3February 19, 2014 by Kenneth Fisher
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
Continue reading -
DBA Myths: An index on a bit column will never be used.
4February 17, 2014 by Kenneth Fisher
Not true. (Or I guess probably wouldn’t be posting about it would I?) Probably the first thing I should point …
Continue reading -
T-SQL Tuesday #51: Doubledown disaster
3February 11, 2014 by Kenneth Fisher
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!. It’s always a gamble when buying …
Continue reading -
Check your SQL Agent history settings before it’s too late!
9February 10, 2014 by Kenneth Fisher
A little while back I was doing some research into a failed job and ran into a slight problem. 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 -
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
2January 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
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 -
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
SQL Studies 