The problem with mirroring is that they use Standard, not Enterprise so would have to go with high safety mode with a 3rd witness server and the principal server waits...

I got it wrong for legitimate reasons as I assumed the question was referring to log backups and not log files, and thought because bulk recovery model minimally logs bulk...

The only hesitation I had is that I use BETWEEN enough to know that it's inclusive at the lower and upper bounds, but don't use NOT BETWEEN very often so...

So the correct answer isn't "No and No" nor is it "Yes and No" but rather "Yes and It Depends" - I think everyone who got a point should have...

I only did the MS instructor-led courses once and realized they were a waste of time/money and covered in class maybe 10% of what's on the test. Since then,...

In my experience, using a DML trigger to create an audit trail of some sort is one of the strengths of a DML trigger. I've used this before in...

The SQL Server 2005 tests will remain as long as mainstream support is in place for SQL 2005, which Microsoft hasn't yet announced an end of mainstream support date for...

Yeah, this QotD threw me for a loop too and I got it wrong, but that's why I love the QotD's because right or wrong, I always learn something new...

powell_todd (6/30/2010)

---

Thanks for the reply, and I understand that in the example of 6 + 2 + + 7, it's acting like it's placing the parens like you indicate. ...

Christian Buettner-167247 (6/30/2010)

---

powell_todd (6/30/2010)

---

What I'm not quite getting is why "PRINT 6 + 2 + + 7" produces 15, instead of some kind of arithmetic error. I don't think...

Good question...

Also, why does this return 1...

select 6+2+-+7

I agree with the posts saying that '5' should've been an option as I would've definitely chose that. When I first read through the answer list, and saw that...

In case anyone hasn't caught it yet, either question or the answer is wrong. If both the seed and increment are -1, then the answer would be -1, -2,...

I just enjoy doing it too as I definitely learn a good bit during the process (plus the company pays for all the books I buy and the tests I...

That was fun and relatively easy... thanks for the question.