Google, the first port of call for all your obscure literature referencing needs 😀

Points well earned? Yes, sometimes it is better to admit you do not know something and seek...

Lost points but learned a feature difference between 2005 and 2008 so points well spent in my book

A good question about which i had no idea so had to take a guess.

With the question title of SSMS feature though i could only see one answer that represented...

You can use a left join checking for Null

select a.*

from TableA a left join TableB b

on a.id = b.id

where b.id is null

If you query sysprocesses when your experiencing the CPU pressure what results do you get back in terms of wait types?

Or if you have performance dashboard installed this will graph...

thanks 😀