Query Performance Tuning: Some Tips on What Not to Do

So far, we have covered a wide range of tips related to optimization in SQL. As a Database Administrator, you may also be aware of these and about what to do when a SQL statement results in a degradation of performance. These include the following: Using DMV for locating slow statements that take time to

Database Query Optimization & Plan Performance Tuning

Database administrators can never afford to ignore SQL database issues because the smallest ones can bring the biggest losses to the organization. At the same time, even a minor scope for change can prove to be a great opportunity for database query optimization. Although one may need a considerable amount of experience to discover such

SQL Performance Tuning: Why We Should Obviate Disk Seeks

A disk seek can prove costly for DBAs for a number of reasons. Generally, a disk can carry out only up to a few hundred seek operations in a second. Therefore, database queries that elicit disk seeking will take more time and can even be exceedingly slow in certain cases.   A few approaches may actually