Another advantage worth considering are licensing costs. Once you've paid for SQL Server and have it running on a given machine, you can create instances to your hearts content. If...

There's a chance, just a chance, that the queries could still be in the cache. Try querying sys.dm_exec_sql_text to see if you can find the query. From there you can...

Excellent. Glad I could help. And thank you for posting the solution. I hate wondering what worked.

Absolutely use the FK's. They protect the data.

I'm not even sure what you mean by "storing it as text." Do you mean that you'd just record what the relationships should...

I would simply run sp_who2 and see if it's being blocked by something and if so, what. If there's a long running transaction or lots of transactions blocking the resources...

Evidently you're not supposed to spit...

Tara (4/16/2009)

---

this query is taking too long to run, is there any alternate...

You owe my company a new monitor.

Ha!

If you know the values of StartDt & EndDt are likely to be, break them down into smaller chunks so that you're only moving certain date ranges.

Jack Corbett (4/16/2009)

---

GSquared (4/16/2009)

---

The Thread has (as I write this) 28 posts in the last five hours. This makes 29. Of course, judging by the last page or...

Grant Fritchey (4/16/2009)

---

Bob Hovious (4/16/2009)

---

This is like following a chain of B-Movie horror films...

First there was.... "The Thread".

Then came the "The Son of Thread".

Future Titles

The Other Thread

Revenge of The Thread

Return...

Sounds like pressure on the memory. Were you capturing performance counters. Do you have Page Life Expectancy? That's a good measure of what's happening with SQL Server memory management.

I'm sorry, but I really don't understand the question. Can you post a bit of sample code for what you're trying to do?

Bob Hovious (4/16/2009)

---

This is like following a chain of B-Movie horror films...

First there was.... "The Thread".

Then came the "The Son of Thread".

Future Titles

The Other Thread

Revenge of The Thread

Return of the...

All I know is, if the THREAD starts to approach 5000 posts, I'm going to hunt it down & kill it before it passes me.