Table variables are not necessarily faster than Temp tables... they do not and cannot be made to use statistics...

Also, if you think that table variables might be faster because they...

Ummm.. Post the code for the offending proc?

Develop a weekly maintenance plan... see Books Online for how...

At the risk of sounding a bit snippy (don't mean to)... the best performance enhancement tool is your brain.  You've already isolated which procs are running slow... look for and...

Absolutely agree on the proper use of a correctly indexed temp table.

Jimmy...

Can't use just 60... that would imply integer math.  It has to be 60.0 to imply that it's a float calculation with decimal places.  I also believe that "value" is...

Ack... my fault... I'm so data-centric that I sometimes forget that SQL Server has to live on a Windows server (except for MSDE, Development Edition, etc).

Nope, I don't know how...

Nice code... just a bit of food for thought, though... correlated sub-queries with triangular joins (a<b) can be as bad or worse than cursors on large tables.  Not advocating cursors...

I'll bite ... what is "E&OE"?

It's not free but you could buy SQL Server Developer's Edition for about 64 bucks if you look around.

Noeld probably hit the nail on the head... the server should be much faster than your desktop machine for multiple reasons...

1.  Memory... chances are your desktop computer has between 512Mb...

Mick,

Yes... you can save pictures in IMAGE datatypes... but it's a really bad thing to do for more reasons than I'd care to post here...

Most folks have seen the light...

TempDb is rebuilt from the ground up on a reboot... this does the trick...

 SELECT CrDate AS LastRebootDate

   FROM Master.dbo.SysDatabases

  WHERE Name = 'TempDB'

Vamsi,

Although there's nothing specific about using character arrays to process the W, o, r, d, s, could you be a bit more specific about what you are trying to do?  There's...

If the suppliers of the data have agreed to provide the data with correct row delimiters,

I guess I don't need to do much.  Too bad... I was "dying" to...