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
Find the modified date of SQL Server Agents Jobs
Divide by zero error
SSIS Interview Questions – Part 1
Moving the tempdb database
Script to Check TempDB Speed
SQL Server buffer pool
View queries waiting for memory grant