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

Top 7 Database Query Optimization Hacks

Database query optimization is a technique through which the database performance is improved by writing thoughtful queries. During the development process, the data is less to work with. It’s easier to get results with less amount of data as compared to a large one. But the problem arises when there are loads of data flooding

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