If you have a minute check the 2 procs - do you get paralellism on the table variable one?  I never did, and believe its due to their lack of...

have a look at sp_makewebtask.

Rich

Another feature of table variables is that they do not get statistics.... which results in some incredibly poor performance when they are misused (particularly by those who think they live...

I went with a mirror for the os, a stripe for tempdb and mirror for logs, with a couple of raid10s for the data.  Worked nicely.

I'd second that raid10 call.  Wrap the raid 5 5 disk into a r10 4 disk with a hotspare.  Or ideally add a load more disks - given the amount...

Welcome

One of my tables is comfortably in excess of 80Gb...  and growing a couple of gig a day... I would love to stick...

The queries are _exactly_ the same.

Sounds silly, but if someones swapped out a temp table with a table variable, or got a variable defn different, or populated a variable with...

Yeah, kinda.  Check out UPDATE STATISTICS in books online.

It takes a table name + index +( several stats name) as parameters.

This allows you to focus on the important stats rather than...

I wonder if you actaully need to tie it back to the job/maint plan, or if this is something you have sidetracked yourself into?  If you do, then you could...

Use the object Ids.

This _sounds_ like the kind of transaction I was on about earlier, where the restart cleans it out... not that I recommend it, but if you can afford the downtime...

Yes, you need to go to backupmediafamily to get the logical and physical paths, but from those you can construct a report detailing the various backups. 

How to tie that...

Or you can query msdb..backupset and the associated tables.

The rule of thumb that I use is that it will take at least as long to kill as its been running.  Probably longer.  Kill <n> with statusonly will tell...

The restart sometimes works when the connection has been trashed somehow.  Perhaps it is a workaround to something that has already been fixed.

In this circumstance a spid has been killed,...