Robert Davis (2/21/2011)

---

david.howell (2/21/2011)

---

Thanks for the very informative article.

Running the first query I see Simple Recovery model and 'ACTIVE_TRANSACTION'

However, running DBCC OPENTRAN report "No active open transactions."

This doesn't seem to...

Thanks for the very informative article.

Running the first query I see Simple Recovery model and 'ACTIVE_TRANSACTION'

However, running DBCC OPENTRAN report "No active open transactions."

This doesn't seem to add up. My...

Thanks,

got it wrong and learning something 🙂

Took a guess and got it wrong, but...

Ran this on 2005 and A is not actually NULL, its an empty string. Maybe its NULL on 2008?

al.gulseth (7/8/2008)

---

I couldn't even get to the guts of this article simply for the fact that I found the grammar/verbiage intolerable. Next time you should get someone who can...

Grammar

😀

What about book2?

Sorry, I am probably wrong in regards to MS SQL Server and nVarchar. I don't have an MS source.

I was thinking of unicode and the term 'multibyte' rather than double-byte.

Unicode...

Good question, made me think about datatypes.

nVarchar can actually use more than 2 bytes for some characters e.g. chinese characters that use 3 bytes.

Sorry. I disagree with you about ~10% of people "seeing" the bit datatype and most people cheating.

I do these questions in order to learn. I don't cheat at them because...

Good question, I'm just disappointed that

OUTPUT inserted.column

returns values that have updated existing values.

And

OUTPUT Deleted.column

returns the existing values that were updates.

I suppose its more info that just which rows...

The explanation is a bit vague.

" This is because the space is counted as a character that needs to be matched. "

While I got the question right, it was...