I, personally Have seen the tempdb growing issue many times and RAM has always been the factor! And because it can be (and it was even acknowledge on the "anwser") why would you...

If you get a long execution time it could be because you may not be getting the remote execution that is needed. Assuming both SQL Server are 2000

Do this:

1. Make...

>>...just having some "play on words" fun is all....<<

I can see that you are an English major after all

I am not talking about windows I am talking about MS SQL Server Agent Jobs. On EM expand Management node on the server where your procedure is. Then Expand Management->SQL Server...

Glad you work it out. I should have started asking for the indexes utilization in the first place

I have a ton of questions but then again this will get you started also

Insert into PunchTrends_CrossTab ( FacId, EntryDesc, Series, Totals )

Select  FacId, 'DCM' as EntryDesc, Series, SUM(DCM)

From PunchTrends_Chart

where...

Really?

create a Job that is scheduled to run once a day at that time and set it so that on the step call your stored procedure

>> They're quick and inconsequential <<

Functions are never inconsequential They force row by row processing in many cases, instead of set based and therefore should be used sparingly (meaning small sets...

First:

You should replace your " for '

Second:

all can be replaced using a case statement that way you make a single pass to the table:

UPDATE Leave_Professional_Funds SET [SApproved] = case ...

Can you post the definition of:

 1. dbo.fnEnumS

2. dbo.fnPosMarketValue

and

does the Quantity value can be negative ?

case statements on order by needs all columns 'returned' to be of the same type or an implicit conversion should be possible

CREATE TABLE is a physical operation ( check the execution plan ) -- It will abort batch if one already exists

To compile "Delete"...

The approach (for the moment ) is to generate the fixed part of the query in a static variable and add the variable...

>>Why does it matter whether it exists, if the DELETE block is not going to be executed? <<

This has to do with the way SQL works. It has to create an execution...