Viewing 15 posts - 121 through 135 (of 656 total)
robert.diley (3/10/2015)What it does log are page deallocations:
"The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE...
March 12, 2015 at 3:43 am
nihie (3/10/2015)
b) and f) are correct answer, as records from child is removed before parent.
WRONG.
As per my earlier replies, TRUNCATE cannot be used if a foreign key is...
March 10, 2015 at 7:31 am
Hany Helmy (3/8/2015)
Never used it before SETUSER, but very good question despite of the date issue.
I'm not sure that it is a terribly useful question. What benefit is there in...
March 9, 2015 at 2:56 am
TomThomson (3/7/2015)
So a nice easy question, and it will be rather disappointing if the correct answers end up much below 100%.
Currently just 61%. And looks like 2% didn't realise that...
March 9, 2015 at 2:08 am
Wish I'd noticed who wrote the question before I answered! I'd have ignored the obvious and looked a bit closer for the 'trick' 😉
March 6, 2015 at 2:48 am
chgn01 (3/5/2015)
March 6, 2015 at 2:37 am
SqlMel (3/5/2015)
... but TRUNCATE statement do not logging.
Oh boy, here we go again...
Unfortunately the discussion seems to be concentrating on the typo/syntax error instead 🙁
March 5, 2015 at 7:01 am
patricklambin (3/5/2015)
Why the b) choice ( truncate BBB , delete AAA ) is not correct ?
The b) choice is not delete AAA, it is truncate[/I] AAA. This will fail for...
March 5, 2015 at 4:20 am
Even ignoring the typo/mistake, the explanation is totally wrong. It is nothing to do with whether the statements are logged, and it is common incorrect) myth that TRUNCATE TABLE is...
March 5, 2015 at 2:27 am
patricklambin (2/26/2015)
Excellent post , Toreador. You are right. The * means only that the value -51 cannot represent any ASCII character for which the minimum value is 0.
Actually that's not...
February 27, 2015 at 2:03 am
Sean Lange (2/26/2015)
How many books make decent movies anyway? The list is pretty short.
Not as short as the list of radio series that make good books 😉
I made myself finish...
February 26, 2015 at 7:57 am
Try it out. You'll get the same result if you have
DECLARE @ VARCHAR = 10
or the following will return 45 (the ascii for '-')
DECLARE @ VARCHAR(3) = 1952 + 03...
February 26, 2015 at 3:58 am
The explanation is wrong, it's nothing to do with 'unassigned characters' (whatever they are).
The variable is declared as VARCHAR, which defaults to varchar(1). The calculation results in -51, which is...
February 26, 2015 at 2:50 am
Owing to the absence of a "select two" hint I almost went for "all of the above", but saw sense and got it right.
I've obviously been doing these QotD for...
February 16, 2015 at 1:22 am
Viewing 15 posts - 121 through 135 (of 656 total)