Down to...

WayneS (4/6/2010)

---

This will get you the system tables. I'll leave it up to you to do the reindexing / updating of stats.

select *

from sys.objects

where type = 'U'

...

Paul White NZ (4/6/2010)

---

Marts (4/6/2010)

---

I am struggling to move it, from what I have read, you should shut off the agent, backup the DB and restore with move, however that...

I really thought the thread would surpass 14k today.

23 to go.

WayneS (4/6/2010)

---

CirquedeSQLeil (4/6/2010)

---

I could make a case for it needing to be both the board and an exam. Without a board review, it makes it easier to game those...

Nicholas Cain (4/6/2010)

---

Something I've not seen mentioned but really should be kept in mind with this is that cost should really not be a barrier to entry. The huge cost...

Have any of our suggestions helped you with this query?

ianstirk (4/6/2010)

---

Hi Jason,

I'm glad you liked the article.

There is an updated version of this script, without the deprecated objects, given in the book I am writing "SQL Server DMVs...

dma-669038 (4/6/2010)

---

I have cleaned up the survey link per feedback.

http://www.surveymonkey.com/s/HLR8V5S

There is no provision for any extra verbage/introduction on top, or to share survey results with others either ( can only...

That's not too...

Break out the lava lamp

Jeff Moden (4/6/2010)

---

I agree......

jcrawf02 (4/6/2010)

---

speaking of lying, cheating, sob's doing schoolwork, why would you bother to copy my answers to review questions in the first week of a 200 level programming course? And...

Thanks Paul for this suggested workaround.

I had been fiddling with that for a bit, and wasn't getting it right. I was overlooking a key part of my query being...

Nice and relevant article. I would have liked to have seen it not use a deprecated object though.