We have just upgraded all our production servers to SQL Server 2000 and are trying to find ways to make our SP's faster.
One option will be to replace all our temp tables with table variables. My concern is that using table variables too much could use up all our memory and thus cause problems. Have any of you had any problems with memory and table variables?
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems