That's what I thought. Thanks for the reference and tip. Much appreciated.

Thanks for the information. The system is a data warehouse, not OLTP. We are looking to improve query performance overall, reducing CXPACKET waits came up as one possibility....

Thanks,

I have raised similar arguments related to storing production data on QA. The information I am receiving is beneficial. There are sound reasons (as you noted) why...

Thanks. Difficult is an understatement.

My next question would be what is reasonable? Are other shops keeping QA and production in sync? If so, what procedures/tools...

Thanks again for all the help and insight. We are going to rewrite the process to eliminate the functions.

Much appreciated!

Thanks again for all the help.

Yes, we rebooted the server, rebuilt all of the indexes, and resampled the statistics. When we compared the execution plans between systems, they were...

Thanks for all the replies. They are very much appreciated!

What continues to be a mystery is why a procedure that has been running since 2005 for 20 minutes...

Sorry, can't post the code but I will try to explain further using an example.

Select ...

column1,

column2,

column3,

dbo.fnFunction (a.Cost1, b.COST2, b.COST3, b.XDate,@CurrentDt) as Cost4,

column5

.

.

.

into #temp from tblsource1 a (3 million...

They are simple calculations, nothing complex. For example, we pass a couple of parms like cost, qty, and unit of measure then return the extended cost as money. ...

Thanks for the reply,

The source table has 3 million rows. We perform a select into a temporary table and calculate various cost columns using functions. Functions are...

Not yet. This is a QA system in a chain of systems (development and production) all SP3a. We are planning to upgrade to SP4, but are not there...

Have you been able to resolve the problem? We are seeing the same issue on a QA server running SQL2000 Std. SP3a and Win2000 Std Sp4. The icon...

Thanks for the info. We're backing it down to 28GB. Does this require a restart of the services?

We have tried all of the above with no luck. I agree there is an underlying process that has moved or is being locked. One change that I...

This is a critical problem for us. Any help at all would be greatly appreciated. We are not sure if this is a windows problem or SQL problem....