My first thought was "this is WAY too easy".

Then again, I did not know about the "With values" clause so I learned something.

Thanks

Great question, learned something today.

Got it right but didn't know that by recompiling the table only the statement referencing that table inside the SP would be recompiled!!

I recently watched...

Interesting.... Thanks!

Good question. Got me thinking a little since I never tried this before.

@hugo: Thanks for the explanation. That rationalization of the restore process is what led me to...

Yeah, I noticed and edited afterwards. Thanks 🙂

GilaMonster (2/21/2012)

---

SqlMel (2/21/2012)

---

Easy question. Thanks!

It's now down to 2% 🙂

Nils Gustav Stråbø (2/21/2012)

---

Good and easy question. Thanks.

I'm surprised that 21% believes that you...

Easy question. Thanks!

Good question.

Can't remember how many times I've had to answer that question but it sure prompted some very interesting posts.

Good job, guys.

Took a shot, failed.

At least I learned something.

Thanks for the question.

sknox (1/18/2012)

---

I got it right for the "wrong" reason: I reasoned that 2 had to be false, because nothing is stored in a view. A view is by definition a...

This was an excellent question. Very odd behavior when using the wizard. These things are always good to know.

Good question. 🙂

I have very limited knowledge about this topic. Took an educated guess and nailed it.

Great question for further reading. Thanks!

In any case... good discussion, good question.

I don't want to sound too cocky here but the "There does not seem to be memory pressure..." part gave me the answer right away.

I do understand why someone would...