OMG! I've worked with SQL Server for over 10 years and I've never heard of assertions. Really. This is the first time I hear there is something like that in...

Thank you Gail, Grant and SQLGuru. Funny how you said look it up yourself but then gave me all the answers discussing the new features amongst yourselves :-):-D

I think...

I have a question... Is it possible to tell SQL Server to use a particular join method? Or do you always rely on the Query Optimizer to choose the most...

I looked at that brochure also before asking this question, I must admit, it is very confusing.

If someone could clarify, I would really appreciate it.

Hi everyone,

I have been considering certification also, although my employer doesn't want to help unfortunately =(

Just want to make sure I understand this correctly: to get MCTS THERE'S ONLY ONE...

Could you please explain why? I mean, why is that line causing an error and what should it...