Viewing 15 posts - 376 through 390 (of 552 total)
Awesome, actually really nice one.
(I had developed imaginary theory on this long back- what if the table is self joined with the key and would truncate work? - and I...
March 28, 2013 at 5:34 am
Good one, thank you for posting;
I actually selected 1 and 4 and really not sure what crossed my mind and I ended up selecting the other two... which lead to...
March 26, 2013 at 3:08 am
Thank you for posting, good one.
Never digged so deep on this area, was interesting to learn.
March 22, 2013 at 4:53 am
Hugo Kornelis (3/21/2013)
...DML is language that inserted, updates, or deletes data. That (deleting data) is exactly what TRUNCATE TABLE does!
Thank you Hugo; but one doubt...
.... but still it is does...
March 21, 2013 at 7:17 am
jpentz99 (3/21/2013)
MS docs sometimes refer to it as a DML operation as well:
"Some data manipulation language (DML) operations, such as table truncation, use Sch-M locks to prevent access to affected...
March 21, 2013 at 3:44 am
good one. thank you for posting.
I guess it is a long fight because neither way it cannot be proved 100% that it is a DML or DDL depending on the...
March 21, 2013 at 3:43 am
peter.row (3/20/2013)
Basic question designed to seem like a trick?This applies equally to SQL Server 2005 and 2008 not just 2008R2 and 2012.
also... including our old friend SQL SERVER 2000
March 20, 2013 at 3:04 am
Simply Nice, thank you for posting.
(i knew this before, and just fews days ago i kind of helped a person online to fix this, so it was easy recall for...
March 20, 2013 at 2:59 am
Simply the best, thank you for posting steve...
(i looked into the thesaurus file location on the hard drive and then noticed eng/enu two files but was not sure which one...
March 19, 2013 at 3:30 am
Awesome Qtod,thank you for posting.
(I am bursting with my doubts... but no idea where to begin...)
so to say... there will be no row/s in the datetime column where it...
March 18, 2013 at 3:07 am
ah ... this was soo easy, i just selected the answer in one click....:Whistling: but selected the wrong one. (interesting read, so far)
March 15, 2013 at 3:31 am
Carlo Romagnano (3/13/2013)
okbangas (3/13/2013)
Learned something new here, and by the way, the reference should be:Good!
+1
March 13, 2013 at 2:59 am
Stewart "Arturius" Campbell (3/13/2013)
Interesting question, thanks DaveAnother way to check the detail of the temp table would be to execute
tempdb..sp_help #TempQoD
Now this is very very new thing to me......
March 13, 2013 at 2:25 am
Viewing 15 posts - 376 through 390 (of 552 total)