Yep. He did do that. When I went and cleaned up the code I removed all those Select * to just the neccessary columns.

He is also the guy that in...

Yeah, I didn't put those tables in my list because they weren't pertinent to the discussion. I'm definitely planning on splitting that out too (if I get the go-ahead)

I agree with all of that. I am going to consolidate this advice into doc for my boss and 'hopefully' he will pay attention to it. But I'm not keeping...

Thanks Frank.

And, no, my boss is not a DB expert (but he unfortunately has dealt with DBs and thus has some knowledge which makes him dangerous).

As for performance, he would...

Tom,

Thanks for your input.

Ok, my question about your suggestion of putting a view in to cover the 3 tables:

What benefit does the view provide? The code can already look in...

Thanks for replying Michelle!

Answering your question: No, only the neccessary columns are pulled back.

As for testing this out, my boss doesn't want to take the time to make a 'test'...