what do you mean by ddl?

you mean sample results?

joshua.scott2 (11/30/2012)

---

I agree with Chris and Jake. I would try to get a better understanding of what the end users are seeing so that you can narrow down your options....

Zeev Kazhdan (11/30/2012)

---

Have you ran any statistics on your database?

How about your transaction log? Do you maintain it properly?

I am not a DBA either, but this what I would look...

any thoughts?