Daily Archives: July 16, 2010

The Wiffle-Waffle, or Why I’m Running for the PASS Board of Directors

I’ll announce it here first, along with some reasons why I’m waffling from an earlier post: I’m going to run for the PASS Board of Directors in 2010. I am finalizing my application and getting reference letters before I send … Continue reading

Posted in Blog | Tagged , | Comments Off on The Wiffle-Waffle, or Why I’m Running for the PASS Board of Directors

SubQuery Performance

Why would you do this? select distinct(hostname),(select count(*) as criticalCnt from @temp where severity_guid=’0168A833-1732-411E-8205-C2F6CD91737D’ and hostname=t.hostname group by hostname),(select count(*) as criticalCnt from @temp where severity_guid=’CB2F2B90-2DA4-4075-BCAA-DD5D2CEFBFD5′ and hostname=t.hostname group by hostname),(select count(*) as criticalCnt from @temp where severity_guid=’C4CF8A23-A106-4617-BAB0-94DA3CA74EF1′ and hostname=t.hostname … Continue reading

Posted in Blog | Tagged , , | Comments Off on SubQuery Performance