SQL Server Tip: Optimizer Using Index Scan and Not Seek!
January 23, 2015
Author: Timur T7253
Introduction
Other than coding, the next biggest task for developers is to troubleshoot problems in their environments. Developers in the SQL world mostly face problems around error messages, getting required output via T-SQL query, and unpredictable performance of queries.
The Problem
One fine day somewhere in the world one developer was troubleshooting a performance problem…