Community

SQL SERVER – Optimize Key Lookup by Creating Index with Include Columns

(Pinal Dave) I love query tuning and performance tuning projects. In one of the recent Comprehensive Database Performance Health Check my client had a very interesting scenario where their queries were running pretty fast earlier but gradually started to run slow and eventually started to take over