Now a days as user base is growing so does the problem of data management. We all face performance related problems while performing sql data operations, so mentioned below are some of the tips you can consider while fetching data using sql server:
1. Fetch Only Required Columns: Rather than fetching all the columns try to fetch columns which are needed by your application i.e.
Replace,
Select * from table
With,
Select col1, col2, col3 from table
