Newbie of a newbie here, I'm working on a web development degree, so not close to being a dba or anything, but wanted to hang out around people who know what they're doing to pick up tidbits.
When I took a SQL class for work, the instructor said that using SELECT * actually made the query look at the table twice, once to find out what was in it, then second to pull values for your query. He suggested picking a column, since in most cases, you're looking for existence anyway. Does that affect anything in your transaction counts? Or was he full of it?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."