What theoretically performs better, a LEFT OUTER JOIN with IS NULL in the WHERE clause or WHERE EXISTS?
Experience Level: Not defined
Tags: DatabasesMS SQL ServerSQL
Answer
Related Databases job interview questions
What first steps would you take to troubleshoot a performance issue?
DatabasesMS SQL ServerSQL Not definedWhat versions of SQL Server have you worked with?
DatabasesMS SQL ServerSQL Not definedWhich high availability technologies have you worked with?
DatabasesMS SQL ServerSQL Not definedWhat is your least favorite part about SSIS?
DatabasesMS SQL ServerSQL Not definedWhat would you consider a good fragmentation percentage to reorganize an index? Rebuild?
DatabasesMS SQL ServerSQL Not defined