INTERSECT and EXCEPT are operators within SQL Server that takes data from two queries and compares the results.
INTERSECT returns the distinct values from both the left query and right query.
EXCEPT is different as it returns...
Database stuck in “Restoring” state
Log shipping Alerts failing to send emails
Divide by zero error
SSIS Interview Questions – Part 1
Querying Microsoft SQL Server 2012 (70-461) – Exam Preparation Questions – Part 3
Moving the tempdb database
Script to Check TempDB Speed
SQL Server buffer pool
View queries waiting for memory grant