SQL Server Query Design guidelines

• SET NOCOUNT ON 
• Explicitly Define the Owner of an Object
• Avoid Non-sargable Search Condition 
• Avoid Arithmatic Expression on the WHERE Clause Column 
• Avoid Optimizer Hints
• Stay away from Nesting Views
• Ensure No Implicit Data Type Conversions
• Minimize Logging Overhead
• Adopt Best Practices for Reusing Execution Plans
• Adopt Best Practices for Database Tranactions
• Eliminate or Reduce the Overhead of Database Cursors

If there is any other better option,

Please share it here or mail to me arkaa4@gmail.com

Thank You,

Arka Gupta.

https://in.linkedin.com/in/arkagupta