This solved my problem.

Thank you so much!

I tried this & I got a conversion error converting datetime to character string. I figured out the error occurred on the conversion of the run_duration column where the column...

GilaMonster (8/1/2011)

---

No its not, but SQL still has to track the run-time information through each one. The plans for the functions are still generated, they don't get returned for management...

GilaMonster (8/1/2011)

---

I suspect in the OP's case it's the functions. If those are scalar functions and they're getting run for each row of the query SQL has to track the...

No, in SQL Profiler it does not seem to slow the query down.

I just checked no hardware errors.

Sure, see attached.

I have worked with execution plans that are much more complex & they have not increased the execution time very much at all.

Hi,

I am seeing this same problem on 2005. Does anyone know if the blog http://vendoran.spaces.live.com/Blog/cns!A1AA2222A8B0305C!311 was transferred to another site?

Thanks for the help.

Forget it. We found it. It was a Database trigger with a select the text of the command.

Thanks to all who looked at my question & thought about...

Yes, I was looking for a diliberate flush with DBCC FREE...CACHE. Sorry I should have been more specific.

Thanks again for the help.

The question in the e-mail does not match the question on the web page.

Yes, that is how it appeared in my e-mail.

These ideas are great, but because of the 3rd party software we are using we are limited to how we can manipulate the tables & data.  The experts say it...

Thanks for the input.  We will try this.  We were hoping to be able to use a ram disk with the NUL Device, so this looks like the best option...

OK.  Thanks for the help on the log file device.  I thought that would probably be the case.

Should we be using the Bulk recovery mode, based on the documentation simple...