What/who is it?

And what was wrong with the lizard?

SanDroid also sent me some inane private messages. Somehow, me not quoting "who guards the guards" in Latin (I wrote it in English) was wrong, referencing Plato in response...

Well done.

SanDroid (4/7/2011)

---

Hugo Kornelis (4/7/2011)

---

I don't have the time to really dive into this at the moment, and I'm also sitting at a computer that is running SQL Server 2005 only...

SanDroid (4/7/2011)

---

GSquared (4/7/2011)

---

Wish Flow charts where better here.

Temp Tables are logged --> MARS...

Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).

San's making the classical mistake of...

SanDroid (4/7/2011)

---

CirquedeSQLeil (4/7/2011)

---

I'll put it out there that I missed it because I went with the none option (meaning all are logged based on question phrasing). I knew table...

If you're going to port to a different RDBMS than SQL Server, you'll have much bigger issues to deal with, most likely, than a few identity columns. If that's...

When you click on the table in Management Studio or Query Analyzer, it should give you a tree that has a Triggers section. Check there.

Jeff Moden (4/4/2011)

---

I think a lot of people miss a real opportunity to make a difference in a young person's life during "work experience". Let them "belt loop" you...

Now you've made me curious what the type was.

I may be missing it, but I don't see all the index definitions that are being used in the execution plans.

IX_CrsEvalResponse

IX_SROffer_CrossList2

Those seem to be missing from the DDL scripts.

And you're...

Subplans are just an organizing tool, like file system folders. Use them if they help you stay organized, don't if they don't. There is no mechanical advantage to...

Brandie Tarvin (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

Brandie Tarvin (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

I remember watching both The Monkeys and Original Star Trek as a kid, but they were both in reruns at that point....

The first thing I'd do is eliminate DISTINCT in the sub-queries. It's completely unnecessary, and it costs CPU cycles at the very least. It is also probably the...