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
Find the modified date of SQL Server Agents Jobs
Script to Check TempDB Speed
PING all the Linked Servers and get a status report
Total Server Memory and Target Server Memory
Moving the tempdb database
SQL Server buffer pool
Log shipping Alerts failing to send emails
View queries waiting for memory grant