SQL Server Interview Questions for Senior Developers — Execution Plans, Indexing, Locking & Parameter Sniffing (Deep Answers)
30 senior SQL Server interview questions with deep answers and real T-SQL: execution plans, indexing, locking & isolation, parameter sniffing, and tuning.