SQL Server Index Backward Scan: Understanding and Performance Tuning
Table indexing strategy is one of the most important performance tuning and optimization keys. In...
Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Recently, I came across an application that generated DB queries. I understand that there is nothing new about that, but when application...
Automatic Data Collection: Database Files and Logical Drives in MS SQL Server
Introduction It is important for a database administrator to know when there is no space on a disk. Thus, it is better to automate the...
