SELECT * | Big Data, Data Analytics and Data Science

SELECT * Vs SELECT Column Name in SQL Server Query

September 2, 2012 Sandip Shinde 4 comments

People always keep saying do not use SELECT * exercise SELECT <column names> instead. But no one put more light on this and this becoming myth in SQL Server and other database management systems. Here are couple of reasons why should we avoid SELECT * and go with SELECT <column names>