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...

mister.magoo (4/13/2011)

---

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

---

I guess I wasn't clear. It takes both. Prepending alone is not enough, it takes EVERYTHING varchar. Even a single nchar in there screws it...

Posting final code... prepending with "correct" order of the tables...

DECLARE @Exec VARCHAR(MAX)

SELECT @Exec = ''

SELECT @Exec = 'UPDATE STATISTICS dbo.[' + CONVERT(VARCHAR(200),name) + '] WITH FULLSCAN ; ' +...

mister.magoo (4/13/2011)

---

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

---

mister.magoo (4/13/2011)

---

That is definitely one to remember! Glad it worked for you as well, as there was the possibility in my mind that it might be version specific.

I...