Oleg Netchaev (8/7/2010)

---

I think that this data type size behaviour is great. Since there is no way in SQL Server to punish the disobedient by, say, 12 lashes they deserve,...

Thanks for question. I just lost one point. 😀

Now why in Heavens would there be two different behaviours for the same datatype?

Just to confuse people? Or is there a technical...

Very nice question.

Fortunately for me, I've come to know the differences of both functions while studying for the MCTS exam.

The best of all are these discussions about the question of...

I chose aynchronous only as well.

Now I've written it down so SQL Audit will be my next subject of interest after my current studies end.

Much appreciated, Steve.

I'll be sincere: I didn't know exactly what to choose.

I got it right after some time thinking but my reason was different from the answer. 😀

I guess I'm just lucky.

And...

I'm still getting ranking functions into my head slowly. 😀

Nice article about a very useful way to use them.

Nice question.

I had to browse my memory from long ago after I saw that VARCHAR declaration. I had forgotten that.

Thanks a lot. 😎

Congratulations, Duncan! 🙂

I passed the 70-433 (MCTS) recently I also had...

For a second I read this:

instead of this:

Option 1 runs faster than Option 2 and is the right choice....

Very nice article. Keep up the good work.

Very well written and informative.

My only complain would be the use of hacks like "always true" or "always false".

The "WHERE 1 = 1"...