201
SQL Server Interview
Advanced Query Optimization
SQL Server interview questions covering advanced query optimization.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
202
What is cardinality estimation?
203
What causes inaccurate cardinality estimates?
204
What are the main physical join operators in SQL Server?
205
How does a Nested Loops join work?
206
How does a Hash Match join work?
207
How does a Merge Join work?
208
What is a Sort operator and why can it be expensive?
209
What is a memory grant in SQL Server?
210
What is a spill to tempdb?
211
What is parallel query execution?
212
What are MAXDOP and Cost Threshold for Parallelism?
213
What is the SQL Server plan cache?
214
What is query recompilation?
215
What is parameter-sensitive query behavior?
216
What is the OPTIMIZE FOR query hint?
217
How can implicit conversions hurt query performance?
218
What is predicate pushdown?
219
How does Query Store help with performance regression?
220