SQL Server Query and Transact SQL Performance Tuning
In Applications where SQL Server is used as a back-end for data storage and manipulation purposes, there are various reasons for SQL Queries or Transact SQL Statements or Code running slow when the Application is executed in a Production Server Environment. Some of the reasons for slow running queries and updates are:
- Low network speed or slow network communication.
- Inadequate memory in the server computer or not enough memory available for SQL Server.
- Improper indexing in database.
- Lack of usage of database statistics.
- Lack of proper database partitioning.
To facilitate development of applications with reliable and faster performance, there are some basic SQL Server Tools and Techniques to enhance the Query and Transact SQL Performance.
Continue reading "SQL Server Query and Transact SQL Performance Tuning" »


