- Use views and stored procedures instead of heavy-duty queries.
- Try to use constraints instead of triggers, whenever possible.
- Use table variables instead of temporary tables.
- Try to use UNION ALL statement instead of
- Try to avoid using the DISTINCT clause, whenever possible.
- Try to avoid using SQL Server cursors, whenever possible.
- Try to avoid the HAVING clause, whenever possible.
- If you need to return the total table's row count, you can use alternative way instead of SELECT COUNT(*) statement.
- Include SET
- Use the select statements with TOP keyword or the SET ROWCOUNT statement, if you need to return only the first n rows.
Loading
