Improve the performance of an Query.

Hi,

Try to follow below steps too,

Use EXISTS instead of IN to check existence of data.
Avoid NULL in fixed-length field.
Avoid Having Clause
Use WHERE expressions to limit the size of result tables that are created with joins.
Use WITH (NOLOCK) while querying the data from any table.
Use SET NOCOUNT ON and use TRY- CATCH to avoid deadlock condition.
Use Table variable in place of Temp table. Use of Temp tables required interaction with TempDb database which is a time taking task.
Use Schema name before SQL objects name.
Avoid prefix “sp_” with user defined stored procedure name because SQL server first search the user defined procedure in the master database and after that in the current session database.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.