How to improve SQL Server Performance

I am giving some points to improve the SQL Server Performance.If you want to improve your application performance, you want to improve your  SQL Server Performance also.

1. Don' t use Select * from tablename. Use SELECT ColumnName FROM tablename instead of it.

Example : Use below Query

SELECT EmpName FROM EmpDetails.

2. Don't use Lower Case in SQL Server statements,

Example : Don't use : select ColumnName from tablename.
                Use Upper case : SELECT EmpName FROM EmpDetails.

3. Don't use "IN", "NOT IN" , "DISTINCT"  in your query. if not required .

4. Don't use "Cross Join" if not required

5. Don't  use Having Clause if not required .

6. Don't  use Cursor if not required

It is very important for increase the performance of the SQL Server.

If you want to improve your SQL Server, you need follow the above tips.

It will help you.

I will add some more point in SQL Server Performance. Thanks for spending your valuable time.
if you have any doubts or any suggestion, Post your comments.