Brandie Tarvin (10/30/2007)

---

Theoretically, you might be right, but in the past I've actually seen an exam where they gave me an example of a database in Simple recovery mode and...

Sorry to break this to you, Brandie, but your comments make no difference on your score. I was told by MSL that they are not evaluated together (and from...

I seem to recall SSC announcing them last time around, so you're already on the list 🙂

Theoretically none of the answers should be wrong on the beta exam. The...

Aaron:

One of the major problems with certs in general is that the skills required to pass the cert are often a tiny subset of the skills required to actually do...

Just one correction: Beta exams do count toward certification, if you pass them.

"Unfortunately, there is not much we can do at this point since the data has already been compressed as much as possible and no matter what we do we have...

There is a little-known control-of-flow statement called "else" ...

Oops, they certainly are ... Luckily, they're both wrong

Okay, I just figured out why I was confused: The id = 1 AND id2 = 2 / id = 2 AND id2 IN (2) queries are each sharing...

Hi Hugo,

What build are you testing against? I just tested this yesterday (9.0.3054) and it didn't work. Note, I may not have actually made a typo--I thought that...

I just realized that I unfortunately made a typo when submitting the question to Steve. The query:

SELECT *

FROM n

WHERE

id = 1

AND id2 IN...

David --

You make an excellent point. However, in all fairness, I did add some verbiage to the question (in parens) about what I meant by "proxy"

That's a SQL Server Agent proxy "account". Totally different than what this question is referring to (proxy "login").

Yelena: I think the BOL entry is badly phrased. The implication is that such errors would ALWAYS abort the batch; but there is nothing to say that lower-severity errors...

Update:

I just ran it in OSQL from a command prompt and it took 1 minute, 28 seconds.  So it seems that the real issue here is not time to do...