SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2009

Heads I win, Tails You Lose

Imagine going to a casino with $100 dollars to gamble. As you enter, you notice a vending machine that sells gambling insurance policies. For a small price, the insurance policy will guarantee to replace any losses that you may incur while gambling. So being a prudent person, you buy one.… Read more

0 comments, 581 reads

Posted in SQLSequel on 22 March 2009

Is it time for SQL Server to have Isolated Transactions?

SQL Server allows nesting of Transactions –in a sense. In truth, there is only one Transaction, with each ‘nested transaction’ serving to increase (and decrease) the @@TRANCOUNT indicator. The transaction can be committed or rolled back at any point that the @@TRANCOUNT value is equal to one. Error conditions may… Read more

0 comments, 728 reads

Posted in SQLSequel on 10 March 2009

MVP Summit 2009 -A Most Excellent Adventure

For many of us, one of the high points of being an MVP is attending the annual MVP Summit hosted in Seattle by Microsoft. Yes, there is a lot of flash and hoopla, good food, and a party or two. But the real value comes from connecting and re-connecting with…

Read more

0 comments, 377 reads

Posted in SQLSequel on 7 March 2009