SELECT * runs slower than listing columns (even when you want everything). If you don’t want every column, you save on network time, disk I/O, CPU, and memory. Every resource SQL Server touches! Even when you need every column though, SELECT * can create issues in JOIN predicates, and causes more CPU to be used. You should instead list just the columns you need, all columns if necessary.
