Tom Brown (5/6/2010)

---

This question must be clearing up common confusions - only 2% got it right so far - thats the worst ratio of correct answers I've seen on...

It's probably only about 500...

TheSQLGuru (5/6/2010)

---

My statement above applies to TVFs also, at least ones that aren't inlined by the optimizer.

I will add that as a consultant in the past 3-4 years I have...

Gianluca Sartori (5/6/2010)

---

Congrats! It's a long way to 8000...

If you're seeing two SP:StmtCompleted entries, then you've got two statements that...

Then, I'd say you're basically OK. You can get...

And by the way, just passed 8000 points. #10 to do so.

Now I'll let Jason & Paul pass me.

It's hard to tell from that, but I'd start in the usual places. Check the service in the Configuration manager and be sure that it's set to a good login....

mckinnj1 (5/6/2010)

---

Wow....

GilaMonster (5/6/2010)

---

GilaMonster (5/5/2010)

---

You can't. CheckDB can only be run against an actual database, not a backup. I belive Paul R worked on something to allow CheckDB to run against a...

mike.renwick-894639 (5/6/2010)

---

I personally haven't found a great deal of info on how to script objects using SMO which is why I think people end up doing slightly scary things like...

Robert Frasca (5/6/2010)

---

Grant Fritchey (5/5/2010)

---

Robert Frasca (5/5/2010)

---

My experience is that function references in the FROM clause, i.e. inner joins, usually dramatically outperform function references in the WHERE clause because the...

That's a good one. It's the way I feel when reading a lot of the questions too.

GilaMonster (5/6/2010)

---

Grant Fritchey (5/6/2010)

---

Gianluca Sartori (5/6/2010)

---

I could try to attach my whole SQL knowledge to that thread,...

I'm with Phil on this one. It was a good read and an interesting solution, but way more difficult than needed since SMO can do so much of the work.

That...