HERE'S THE SIMPLE ANSWER:
WHEN YOU USE 'IN', WHILE CHECKING FOR WHERE CONDITION SQL 
SERVER ENGINE DOES WHOLE TABLE SCAN.
IF YOU USE 'EXISTS' AS SOON AS ENGINE FINDS THE REQUIRED 
ROW IT WILL STOP EXECUTING QUERY AND GOING FURTHER SCANNING 
TABLE. 

SO BASICALLY EXISTS IS FASTER AS COMPARED TO IN.