\n\tIt is commonly known that you should not use SELECT * when you are writing a query.
\n\tMost of the times, we only need a some of the columns that a table has and we should retrieve only those columns.
\n\tThis are some of the disadvantages of using Select * :
\n\t
\n\t1. Debugging is very difficult and time consuming
\n\t2. When the structure of a table is modified by adding new columns views, functions or stored procedures requiere additional atention manually refresh in case of malfunction.
\n\t3. Increasead network traffic by retrieving unnecessary columns
\n\t4. In most of the situations the clustered index is used instead of the optimal index.
\n\t5. Sub-optimal execution plan\n<\/p>\n
\n\tHere are two practicle, easy and quick ways to avoid the use of Select * :\n<\/p>\n
\n\t1) Drag the Columns folder from SQL Server Management Studio to Query Editor and keep only the columns that you need
\n\t2) Right Click on a Table >> Script table AS >> Select to… >> Select an option from : – New query window \/ – Clipboard \/ – File \/ – Agent Job\n<\/p>\n
\n\tLucian Leonte
\n\tPMP, ITIL, MCT, MCITP, MCTS\n<\/p>\n
\n\tPowered by CodeReview – Let's make it Better!<\/a><\/strong><\/em><\/p>\nShare this:<\/h3>