sql server programming: I have a Stored procedure which includes several Table variables which have
joins to other table with in the database. What is my best strategy to aid
in the stored proc's speed.

Thank you

Without actually seeing the code and tables that is pretty hard to say. Do
you have proper indexes on the tables? Have you looked at the query plans?

--
Andrew J. Kelly SQL MVP


[quoted text, click to view]

This is an open ended question to say the least. The best answer here is to
read a book on database design, then a book on stored procedure programming,
and then a book like Inside SQL Server. Between these three resources the
answers will reveal themselves.

Seriously, good table design is the place to start. Now if you have a very
specific question about performance problems you are having it will be much
easier to answer.

--
----------------------------------------------------------------------------
Louis Davidson (drsql@hotmail.com)
Compass Technology Management

Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266

Note: Please reply to the newsgroups only unless you are
interested in consulting services. All other replies will be ignored :)

[quoted text, click to view]