August 29, 2016 at 9:54 pm
Comments posted to this topic are about the item DDL and TRANSACTIONS
August 29, 2016 at 10:50 pm
This was removed by the editor as SPAM
August 30, 2016 at 1:26 am
Nice question..!!:-)
August 30, 2016 at 1:38 am
Nice to start week...!!!
August 30, 2016 at 2:56 am
Good straightforward question.
It's a bit disturbing that about a third of answers so far are wrong on someting as fundamental as this.
Tom
August 30, 2016 at 5:07 am
TomThomson (8/30/2016)
Good straightforward question.It's a bit disturbing that about a third of answers so far are wrong on someting as fundamental as this.
Agreed, but there was another QOTD recently that dealt with DDL being able to be rolled back and, IIRC, it showed that it needed reinforcement.
August 30, 2016 at 6:39 am
Good question, thanks.
August 30, 2016 at 7:02 am
Ed Wagner (8/30/2016)
TomThomson (8/30/2016)
Good straightforward question.It's a bit disturbing that about a third of answers so far are wrong on someting as fundamental as this.
Agreed, but there was another QOTD recently that dealt with DDL being able to be rolled back and, IIRC, it showed that it needed reinforcement.
Yes it did. It does seem to have improved slightly. As of this comment the incorrect answers have decreased to 21%. Of course there are still only 339 responses.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 30, 2016 at 9:02 am
The DDL and transaction myth might come from Oracle and deformed badly. Hopefully, the myth that DDL is not affected by transactions will be gone eventually.
August 30, 2016 at 11:37 am
Back to basics... Thanks, Sergey!
August 30, 2016 at 11:48 am
Luis Cazares (8/30/2016)
The DDL and transaction myth might come from Oracle and deformed badly. Hopefully, the myth that DDL is not affected by transactions will be gone eventually.
That's likely where it originated. I also hope the myth dies out.
September 7, 2016 at 6:40 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply