What theoretically performs better, a LEFT OUTER JOIN with IS NULL in the WHERE clause or WHERE EXISTS?
Experience Level: Senior
Tags: DatabasesMS SQL ServerSQL
Answer
Oops, we don't have the answer yet...
Ask our expert directlyRelated Databases job interview questions
What first steps would you take to troubleshoot a performance issue?
DatabasesMS SQL ServerSQL MediorWhat versions of SQL Server have you worked with?
DatabasesMS SQL ServerSQL JuniorWhich high availability technologies have you worked with?
DatabasesMS SQL ServerSQL SeniorWhat is your least favorite part about SSIS?
DatabasesMS SQL ServerSQL SeniorWhat would you consider a good fragmentation percentage to reorganize an index? Rebuild?
DatabasesMS SQL ServerSQL Senior