samalex (10/6/2010)

---

Hey Guys --

Thanks for the great advice, but the problem we're running into is we don't know if a client will want cash flows and other tables that roll...

I don't completely understand what's going on, so please excuse my ignorance.

First, can you explain in further detail why you can't have constraints?

I'm not a huge fan of GUIDs,...

Even without an execution plan, I count five (5) different IN statements and I see a number of functions on columns in the WHERE clauses. Those alone will kill performance.

What about setting up a server side trace to monitor for that query? You can capture who is calling it, when, from where, pretty much everything you need.

Although, using sys.dm_exec_requests won't show blocking if parallelism is involved.

Another way to do it, and you can use almost the same query, is to look at sys.dm_os_waiting_tasks.

Less than a thousand to go. I think it'll take another couple of days, but it's sure to be this week.

GilaMonster (10/5/2010)

---

I'll disagree slightly...

Books alone will not make you a master. Books + experience + experimentation may, with sufficient...

Derrick Smith (10/5/2010)

---

Or script out the schema, recreate, and then to a data flow task for every table (you may need to drop all foreign keys, insert data, then recreate...

Not even a little bit. Very clear, to the point, fact based... looks fine to me.

Sorry, not...

John__A (10/5/2010)

---

Grant Fritchey (10/5/2010)

---

I wouldn't try it that. Instead, script out the 2008 database to a script or set of scripts. Then you can run those on the 2005 instance,...

Alvin Ramard (10/5/2010)

---

Waving a shiny piece...

I can't point to specifics, but I've seen anecdotal evidence that suggestions in some edge cases, the changes to the optimizer between 2000 and 2005 can product sub-optimal execution plans....

GilaMonster (10/5/2010)

---

And just when I thought the project I'm on couldn't get any worse..

We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...

A friend of mine just posted an excellent little PowerShell script that might be something you're looking for. Check out Aaron Nelson's blog post[/url].