Thanks David, amazing description of what "might" be going on under the covers. Certainly makes a lot of sens and demonstrate how much work is actually involved.

That also answer...

Thanks, fortunately they don't.

The code's been...

jremmc (4/14/2011)

---

Great article! (Unfortunately when I tried to rate the article I only got one star highlighted and then the system grabbed it, which is why I usually bypass ratings...

No doubt there.

That was supposed to be a quick 2 minutes "job" to test the outcome of full recompile.

I'm well aware of logging limits and single thread, but why I...

kent.kester (4/14/2011)

---

One of my favorite stories about job hunting was years ago during the bubble (dot-com not housing). I saw a job posting for what looked like a bunch...

The report definition is actually stored in a db somewhere, I just can't tell you where.

Now assuming that it is still in xml you can parse it.

Also there's an export...

Nicely said Gail :hehe:.

Brandie Tarvin (4/13/2011)

---

Ninja's_RGR'us (4/13/2011)

---

It actually could. If it fails to finish in the allowed time I need to be able to start back...

Jeff Moden (4/13/2011)

---

Ninja's_RGR'us (4/12/2011)

---

How much data did you test with? I have over 8300 tables to concatenate. On top of that the table names or fairly long, here's...

It actually could. If it fails to finish in the allowed time I need to be able to start back where it was.

If...

sp_who2?

sys.sysprocesses?

How many reports?

One simple way is to start a trace and run all the reports manually. You won't get much faster than this AFAIK.

Same difference... all office products have VBA and can be harmful.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Please post in another format. Most people won't risk opening an excel file (VBA code too dangerous).

Well for 1 I think your function is way too complexe for no good reason.

I also use a calendar table. I have all dates between 2000 and 2040, including...