I just read a pretty good post by Jon Galloway about SELECT * queries. It can be found here: http://weblogs.asp.net/jgalloway/archive/2007/07/18/the-real-reason-select-queries-are-bad-index-coverage.aspx