Good question!

Thanks.

😛

I tried on my production server:

I got interesting results

ordering by [Total IO] instead of [Average IO].

Thanks!

cengland0 (3/30/2012)

---

This one was so easy that I was looking for the "trick." I kept look and looking but never found one so I finally submitted my answer. ...

New features are welcome!

But, I get it wrong!

😛

Easy question!

Good practice is never use "SELECT * FROM" in view, too.

😉

Is there difference between SOME and ANY?

Can someone explain?

+1

Thank you very much.

GilaMonster (3/19/2012)

---

The RowLock (or pageLock) hints just say what the locks should start as, nothing more. In this case they'll start as row, but once past the 5000 or so...

I get it right, but I do not like this kind of question.

😎

R.P.Rozema (3/8/2012)

---

To finalize this: My explanation is wrong and my question + answer was correct only by luck.

The proper explanation has been given in this thread. To be sure I...

R.P.Rozema (3/8/2012)

---

So am I, as I was very sure I had...

R.P.Rozema (3/8/2012)

---

You have left off half of the explanation in your quote. In the next sentence the use of parenthesis to override this behavior is explained:

To preserve duplicates in only...

I get it right, but I disagree with explanation:

If at least one 'Union' is used, duplicates will be removed from the entire final result set, no matter where the 'Union'...

What do you mean for "created and loaded database"?

Good, very good article!

Thank you!

🙂