• Grant Fritchey (9/25/2012)


    In your situation, I think you're right to focus on getting your queries to run as efficiently as possible. You won't be able to dictate hardware, so your maximum efficiency will be from tuning the queries.

    Unfortunately that's the way to so since hardware is bad and upgrades are out of the question...

    Yeah, that book is an OK introduction. I'd also suggest getting a copy of Louis Davidson & Tim Ford's more detailed book, Performance Tuning with SQL SErver Dynamic Management Views. You can get a free copy of it as a digital copy. You might also want my query tuning book. No free versions. Sorry.

    Already bought your book 😀

    Thanks,

    Pedro



    If you need to work better, try working less...