Browse by Tags

• atlanta
• COALESCE
• date
• datetime
• ISNULL
• memory
• New England
• no more guessing
• nullability
• PASS
• Performance
• Query Tuning
• Speaking
• sql saturday
• sql server connections
• TechEd
• T-SQL

• 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 | 17 Comments Filed under: memory, Optimization, PASS, Performance, Query Tuning Attachment(s): Machanic_PASS2011_WorkspaceMemory_Demos.zip

• Where Can You Find Me the Rest of This Year?

  Autumn is creeping inevitably closer here in the US, and that means that speaking season is about to kick into high gear. Here's my current schedule for the remainder of the year: September 8, 17:00 GMT (online) - 24 Hours of PASS webcast: "Baseline Basics Read More... Posted Sunday, August 21, 2011 9:28 PM by Adam Machanic | 0 Comments Filed under: atlanta, New England, no more guessing, Optimization, PASS, Performance, Speaking, sql saturday, sql server connections, TechEd

• TechEd 2011 - Performance Tuning and Optimization in SQL Server 2008 R2 and SQL Server Code Named "Denali"

  Thanks to everyone who took the time out of their conference experience to join Mike Wachal and me for yesterday's session on SQL Server performance tuning! For those who weren't there, we focused in on troubleshooting techniques, highlighting some of Read More... Posted Wednesday, May 18, 2011 1:05 PM by Adam Machanic | 2 Comments Filed under: no more guessing, Optimization, PASS, Performance, TechEd Attachment(s): Machanic_TechEd2011_Demos.zip

• Revisiting ISNULL, COALESCE, and the Perils of Micro-Optimization

  Almost six years ago--in November of 2004--I posted what would turn out to be one of my most popular blog posts in terms of number of reads, " Performance: ISNULL vs. COALESCE ." (If you're curious, the post is dated July 2006 because I was too lazy it Read More... Posted Wednesday, June 30, 2010 2:12 PM by Adam Machanic | 11 Comments Filed under: COALESCE, ISNULL, nullability, Optimization, Performance

• What Happened Today? DATE and Date Ranges Over DATETIME

  A few days ago Aaron posted yet another fantastic entry in his Bad Habits series, this one discussing mishandling of date ranges in queries . This is a topic near and dear to me, having had to clean up a lot of poorly thought out code in the past few Read More... Posted Tuesday, October 20, 2009 3:21 PM by Adam Machanic | 17 Comments Filed under: date, datetime, Optimization, Performance, T-SQL

• 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 | 18 Comments Filed under: Optimization, Performance, Query Tuning

• Controlling Stored Procedure Caching with ... Dyanmic SQL?!?

  Tell me if this situation sends a chill down your spine: You've written a stored procedure, tested it against a variety of inputs, and finally rolled it out in production. All is well... Or so you think. You start getting complaints from some users that Read More... Posted Wednesday, July 12, 2006 10:19 PM by Adam Machanic | 3 Comments Filed under: Optimization, Performance, T-SQL