Reasons of poor performance of query

Reasons of poor performance of query.

Following are the reasons of poor performance of a query:

- No indexes.
- Excess recompilations of stored procedures.
- Procedures and triggers without SET NOCOUNT ON.
- Poorly written query with unnecessarily complicated joins.
- Highly normalized database design.
- Excess usage of cursors and temporary tables.
Ways to troubleshoot performance problems in SQL Server
SET SHOWPLAN_ALL ON, SET SHOWPLAN_TEXT ON, SET STATISTICS IO ON.......
Steps to secure an SQL Server
Use NT authentication. Use server database and application roles to control access to the data. Secure the physical database files using NTFS permissions.......
What is a deadlock and what is a live lock?
When two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece........
Post your comment