Monthly Archives: December 2013
-
The 12 days after release
3December 24, 2013 by Kenneth Fisher
On the first day after release my developer gave to me a performance problem on a crucial query On …
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.
Leave a commentDecember 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
3December 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 -
Undocumented functionality in FORMATMESSAGE
2December 9, 2013 by Kenneth Fisher
I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which …
Continue reading -
Insert into a table using only default values
3December 4, 2013 by Kenneth Fisher
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value …
Continue reading -
Why do DBAs like to say “It Depends” so much?
Leave a commentDecember 2, 2013 by Kenneth Fisher
Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice …
Continue reading
