Following up a little more on my earlier comment...

The hardware issue is also covered by disc mirroring on our production servers. The most common "disaster" I have had to deal...

I disagree with the answer, but I guess it depends on your definition of "disaster". Having to restore a database because of hardware failure is extremely rare. Much more common...

Collation is another battle I have scars from already. This is actually a SQL Express application and I had to write the install for the product and SQL Express. Because...

Even though you have a few, I figured I would let you know what I have done. I didn't want to chage the production code but test what happened when...

I have had that discussion with other developers here and I thought SQL did a pretty good job. I lean toward creating single statements whenever possible to give SQL server...

Grant Fritchey (10/17/2008)

---

What do the indexes on these tables look like? For example, because of this statement:

AND ap.ProcedureID <> ap1.ProcedureID

If ProcedureID is the leading edge of the index used...

Thanks. I may try the temp table. The reason I didn't try to provide all sorts of detail is that I was/am trying to ask a somewhat generic question. If...

I figured it out - a bonehead move on my part. We keep our database in source control by scripting it with DB Ghost. To get changes, I script anything...

I am running my own server instance on my machine; I have total control.

Still nothing.

That fix does nothing for me; still zero records from a datbase that is very suspect as far as optimization goes. I am not a DBA and this database is...

What steps do you need to take to prepare a database for this to return anything? I run it on our database, which has over 400 tables and over 1000...

Jeff Moden (9/19/2008)

---

No... hiring a DBA would solve the problem. The hard part, it appears for most managers, is actually finding a DBA and not some cowboy that thinks...

Don't worry about me; I am cocky enough about what I do well to take a beating on what I can't without wincing (much 🙂 )...

I have learned a few...

Jeff Moden (9/19/2008)

---

p.s. I also want to say that when I say "developers", I'm talking about the greater populous... there are some individual developers that I'm NOT including in...