It could be page splits. What is the fill factor on the index you rebuilt and are you updating a variable length column (e.g. a VARCHAR or NVARCHAR) that either...

You can script the jobs from prod using SSMS but note that it will include the schedules.

Bad

And just to confirm, when you run this in SSMS what does it do?

exec PHIL_App..Rpt_JobTransactionsSp 'SRMQDIC','ROD','B','HNS','0','B',null,null,null,null,'000','9999','1/1/2013','3/17/2013',null,null,null,null,null,null,null,null,'T',null,null,'1','0','1033'

Have you modified SSMS so you can see the entire...

I do not think you...

I just want to start out by saying that I have enjoyed our dialogue very much and that anything coming across as criticism is not meant to be taken as...

Anytime. Thanks for the feedback.

Batches or queries that do not have temporary tables can still use tempdb. For one of many possible examples, if the execution plan has a Sort operator and there is...

64-bit SQL Server still uses the AWE APIs to allocate memory in Windows. No need to worry there. Just set 'max server memory' properly and off you go.

Evaluation Edition is equivalent to Enterprise Edition in terms of functionality and affords 180 days of use. For all licensing compliance information though, never accept the guidance of someone on...

Developing something like this yourself will takes years to perfect and will be low quality if you devote only a small number of resources towards it. Companies like MelissaData have...

There really is not enough info to say for sure what would be best for you, but one misconception I picked up is "choke point is read/write speed of disk"...

That links to a technique relevant for MySQL...this is a Microsoft SQL Server Forum :ermm:

I think you are either being killed by a database "sweeper" process (see Gail's response) in which case you can see that in the SQL Error Log (look for "kill"...