what is the professional way of writing query in sql server?

Question

what is the professional way of writing query in MS SQL server ? Need Sample example ?

Vishal Jadav · Answer

Hi As kunal said there are no professional ways to write a sql query. You have to keep performance in mind. Thanks. :)

Kunal Vaishya · Answer

Hi  There is no professional way to write query in MSSql. But keep in mind and follow some steps during the query writing that would be good for performance of your query. Think about only performance not writing ways. 1. Avoid unnecessary joins. 2. Avoid loops and cursor. 3. Creation Indexes. Etc.... Regards Kunal.

Midhun T P · Answer

Hi There are plenty of articles available in c-sharpcorner itself. Please go through below articles - http://www.c-sharpcorner.com/uploadfile/f3068a/sql-server-query-optimization-day1-basics/ http://www.c-sharpcorner.com/uploadfile/f3068a/sql-server-query-optimization-day-2-no-of-joins-does-mat/ http://www.c-sharpcorner.com/article/how-to-optimize-an-sql-query/ http://www.c-sharpcorner.com/UploadFile/ff2f08/tips-to-improve-sql-database-performance/