MarlonRibunal (2/10/2010)

---

You can either query the Object Catalog View or the Information Schema View.

to return user tables and their columns:

-- Object Catalog

SELECT T.NAME AS , C.NAME AS [COLUMN...

RBarryYoung (2/10/2010)

---

RBarryYoung (2/10/2010)

---

Yeah, there's just something about feeling like I have a screwdriver jammed up my spine...

RBarryYoung (2/10/2010)

---

which one was that? I can't seem to...

I really need to get into doing SB and event notifications - that looks like a lot of fun. 😎

Barry is in a smackdown mood today. That's two on the day.

Armageddon

or a surrogate (reference movie)

Jeff Moden (2/10/2010)

---

GilaMonster (2/9/2010)

---

Steve Jones - Editor (2/9/2010)

---

Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not...

You're not the first to believe that this table behavior is crap at the best. Many people have suggested that it be changed. SMO, is how SSMS knows...

So you can take a sick day?

Or even you use the appropriate settings and order to force a mindmeld / one way merge replication. Then we could just transfer knowledge directly to them :alien:

The union all is properly placed. The formatting of the question is a little awkward - so it looks wrong at first glance.

Thanks (Matt) for the question.

Nice compilation of some of the practices that make for poorly performing queries.

Keep em coming. Nice comic.

GilaMonster (2/9/2010)

---

CirquedeSQLeil (2/9/2010)

---

GilaMonster (2/9/2010)

---

george sibbald (2/9/2010)

---

I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed...