THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Optimization » Query Tuning   (RSS)
  • PASS Summit 2011 - Zen and the Art of Workspace Memory - Demos

    What a rush. Standing on the stage in an almost-full 1,000-person room, I (very) momentarily wondered what I'd been thinking when I submitted a 500-level talk for the biggest SQL Server conference in the world. But despite a rough start--my laptop crashed and I had to reboot it two minutes into the talk--I found my rhythm and the entire 90 minutes ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 16, 2011
  • Exploring the secrets of intermediate materialization

    When working with SQL Server 2000, I used to have this little trick I'd pull out after exhausting all other ideas for tuning a query.  And I thought that my little trick was dead in SQL Server 2005, but thanks to fellow SQL Server MVP Rob Farley, I am officially reviving my trick from the dead here and now, in this blog post.... But first, ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 3, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement