Don't Use Select * in Database Queries
June 3, 2005[From ASP101]
Something you see in a lot of database access code is a select statement that looks something like this:
SELECT * FROM TableName WHERE ...
While there's technically nothing wrong with it, using the SELECT * syntax could be stealing away precious performance from your application, and even it it's not now, it might someday soon.
The article continues at http://www.asp101.com/tips/index.asp?id=125