• This article has been invaluable to me:
    Slow in the Application, Fast in SSMS?