Nakul Vachhrajani (4/15/2012)

---

The way I interpreted the question was:

1. Database is in full-recovery mode

2. User foresees bulk-operations (i.e. to be performed sometime in the future)

3. User therefore changes the database...

I do not like this kind of EXTREMELY easy questions.

😀

Another tricky and bad worded question.

In the earlier versions of any DBMS, the foreign key was implemented thru triggers.

So the answer should be "YES, implemented by trigger."

Or change the question:...

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...