Browse by Tags

• memory
• PASS
• Performance

• 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 Read More... Posted Sunday, October 16, 2011 9:23 PM by Adam Machanic | 18 Comments Filed under: memory, Optimization, PASS, Performance, Query Tuning Attachment(s): Machanic_PASS2011_WorkspaceMemory_Demos.zip

• 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 Read More... Posted Tuesday, October 03, 2006 11:18 PM by Adam Machanic | 25 Comments Filed under: Optimization, Performance, Query Tuning