With SQL Server 2005 you also have the opportunity to Include additional columns in your index.  This is in BOL at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d198648d-fea5-416d-9f30-f9d4aebbf4ec.htm

"An index with included nonkey columns can significantly improve query...

caveat:  Good luck changing a system table in 2005

I learned a good deal about inertia as a kid.  Being I was much smaller then the neighborhood kids, I was always getting trampled in front-yard football scrimmages.  Eventually I...

I've index table variables many times:

declare @table table (id int not null primary key . . .

I think the only thing you should teach is how to lock themselves out of they system until they get some training.

I've seen generic lookup tables work very well.  In the situation I was in there was a view off of the generic lookup tables that returned the data that was...

I'm betting its an ownership or permissions issue, especially if you can run it but your boss and the sql agent can not.

Stored procedure.  It is easier to handle errors in a stored procedure then in the job.  If the stored procedure returns an error then you can log it to a...

Thanks for your help. Apparently sp_executesql will not allow the concatenation, unless you know a way.