Daily Archives: July 16, 2010

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

Posted on July 16, 2010 by way0utwest

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

Posted on July 16, 2010 by way0utwest

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