Which IE version? One should be very careful to post an answer referring to a specific application without an explicit version. Sorry but not all machines will have the same...

tommyh (8/22/2011)

---

So BOL is wrong. From the link

It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for a...

Excellent article and great discussion about it here! Thank you.

Best regards,

Hahahahahahaha.

The "distributed" part was hilarious. 😀

Best regards,

christian.stahl (8/30/2011)

---

@heb1014:

When I ran your test against a table with 18,399 rows I got these results:

if exists (select count(*) from A )

print...

Sometimes when something is very obvious I think to myself that there must be a catch or an SQL Server limitation of some sort. The only other possible answer was...

Great article. Thank you.

Best regards,

I though to myself if this was a tricky question when I read it... I'm glad it wasn't.

@Data_God: I guess what the script is doing is reconfiguring your filegroups because...

Although I have read a book or two to study for the exams I must say that BOL has become a wonderful reference specially with the many examples illustrating every...

That's a great question but it doesn't seem too consistent. I would expect the query to return no errors only if both ARITHABORT and ANSI_WARNINGS were set to OFF.

Best regards,

mike.mcquillan (8/7/2011)Forget the exam for a moment - to make yourself more marketable and to help you win those bigger salaries, you need to keep improving your skill set. Learning...

Easy question. You get it right by analyzing the innermost queries first and then understanding how the NOT IN operator works in the outermost query.

I love this kind of questions....

Indeed. But...

T-SQL is not a priority for DBAs, IMHO.

I know...

I wonder when the new Denali exams will be ready and if they will make those exams "legacy". Maybe the 70-432 and 70-450 will still be valid for another 4-5...