March 30, 2013 at 11:15 am
Comments posted to this topic are about the item SQL Server Error Handling
March 31, 2013 at 9:26 am
Interesting, I can use that set option in SP1 of SQL 2012.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 31, 2013 at 11:12 pm
Easy question and lots of points.:w00t:
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
April 1, 2013 at 12:07 am
Ahhhhh........ I lost the chance to grab a lot of points
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2013 at 1:07 am
I dindn't get any results on googling. So i guessed there won't be any such set options introduced yet in MS SQL Server.
Thanks for easy points..
--
Dineshbabu
Desire to learn new things..
April 1, 2013 at 3:32 am
Awesome. Thank you for question and the points.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 1, 2013 at 5:02 am
SQLRNNR (3/31/2013)
Interesting, I can use that set option in SP1 of SQL 2012.
Not having yet moved to SQL 2012, I had to wrote my own sp to do this. The new feature will be a real time saver.
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
April 1, 2013 at 5:54 am
Amusing question :-P.
Timeouts can cause rollback, but rollback pays no attention to them if they happen while it is executing - it just ignores it - because the whole concept of rolling back a rollback is just plain silly.
I thought everybody knew that until I saw 40% wrong answers :w00t: for this question.
Tom
April 1, 2013 at 8:22 am
I knew this had to be a trick question because I couldn't see why MS would add that command. As Tom said, rolling back a rollback is nonsense. Being April Fool's Day helped with my answer decision too.
April 1, 2013 at 8:32 am
Yet another humor question that went right over my head. I really should stop answering these before coffee... there go seven whole points! :crying:
April 1, 2013 at 9:28 am
Thanks. Steve!
April 1, 2013 at 9:29 am
I found this option in SQL 2020 SP4
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
April 1, 2013 at 9:32 am
chgn01 (4/1/2013)
I found this option in SQL 2020 SP4
Sweet
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2013 at 11:51 am
awesome..
I got 7 points..
April 1, 2013 at 1:36 pm
KWymore (4/1/2013)
I knew this had to be a trick question because I couldn't see why MS would add that command. As Tom said, rolling back a rollback is nonsense. Being April Fool's Day helped with my answer decision too.
Actually I think I misread the question (actually I diodn't bother to look at what the command was supposed to mean, and interpreted it as meaning something else - that kind of mistake is even siller than misreading - but it made no real difference.
Tom
Viewing 15 posts - 1 through 15 (of 31 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy