Tag Archives: microsoft sql server
-
Using SQLFiddle
2March 3, 2014 by Kenneth Fisher
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one …
Continue reading -
What’s the difference between a temp table and a table variable?
3February 24, 2014 by Kenneth Fisher
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the …
Continue reading -
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 -
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
SQL Studies 