Browse by Tags

• .NET
• activity
• ADO.NET
• anti-patterns
• Architecture
• atlanta
• blocking
• COALESCE
• code generator
• cursors
• data education
• database maintenance
• date
• datetime
• demos
• DMVs
• ETL
• exec
• extended events
• gaps
• indexing
• insert
• islands
• ISNULL
• kimberly tripp
• lock escalation
• logging
• logic
• malpractices
• memory
• MERGE
• monitoring
• New England
• new york
• no more guessing
• nullability
• Optimization
• OUTPUT
• parallel processing
• parallelism
• PASS
• PASS 2009
• paul randal
• procedure cache
• puzzle
• query plans
• Query Tuning
• scalability
• Scripts
• software development
• Speaking
• sql saturday
• sql server 2008
• sql server connections
• SQLCLR
• SQLQueryStress
• string splitting
• TechEd
• Testing
• time
• training
• T-SQL
• T-SQL Tuesday
• who is active
• xml

• TechEd 2013: Demos for "Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR"

  Today at TechEd in New Orleans I delivered a breakout session entitled " Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR ." This session covered a number of techniques for using SQLCLR as a query tuning tool, especially for big, Read More... Posted Tuesday, June 04, 2013 1:23 PM by Adam Machanic | 0 Comments Filed under: parallel processing, Performance, SQLCLR, TechEd Attachment(s): TechEd2013_Data_Faster.zip

• SQL Saturday #220 (Atlanta): Demos

  Today at SQL Saturday #220 in Atlanta I presented a new brand new session , "SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches." This session is designed to help people quickly analyze query plans and find likely Read More... Posted Saturday, May 18, 2013 3:33 PM by Adam Machanic | 1 Comments Filed under: atlanta, demos, Performance, Speaking, sql saturday Attachment(s): sqlsat220_queryplans.zip

• SQLCLR Performance Session at TechEd US

  I am super-excited to visit New Orleans next month for Microsoft TechEd; it will be my sixth time speaking at the show. My session takes an in-depth look at some of the techniques I've developed for using SQLCLR modules -- and some of the great performance Read More... Posted Wednesday, May 08, 2013 1:14 PM by Adam Machanic | 0 Comments Filed under: Performance, SQLCLR, TechEd

• Query Tuning Mastery at PASS Summit 2012: The Video

  An especially clever community member was kind enough to reverse-engineer the video stream for me, and came up with a direct link to the PASS TV video stream for my Query Tuning Mastery: The Art and Science of Manhandling Parallelism talk, delivered at Read More... Posted Tuesday, November 13, 2012 10:49 AM by Adam Machanic | 4 Comments Filed under: parallel processing, PASS, Performance, Query Tuning

• Query Tuning Mastery at PASS Summit 2012: The Demos

  For the second year in a row, I was asked to deliver a 500-level "Query Tuning Mastery" talk in room 6E of the Washington State Convention Center, for the PASS Summit. ( Here's some information about last year's talk, on workspace memory. ) And for the Read More... Posted Monday, November 12, 2012 12:00 AM by Adam Machanic | 16 Comments Filed under: parallel processing, PASS, Performance, Query Tuning Attachment(s): Machanic_PASS2012_Manhandling_Parallelism_Demos.zip

• 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

• SQL Saturday 89 - Atlanta GA - Materials

  Last Saturday, September 17, I was lucky to be able to present two sessions at an excellent SQL Saturday in the Atlanta area. The day drew a large crowd and had a great speaker lineup. All in all, a huge success, and a very well-managed event. Congratulations Read More... Posted Saturday, September 24, 2011 1:57 PM by Adam Machanic | 0 Comments Filed under: atlanta, parallelism, Performance, sql saturday Attachment(s): machanic_sqlsat89_DMOs.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

• Performance, Discounts, and an Excuse to Visit New York City

  A couple of weeks ago I announced a two-day advanced performance seminar in New York City, which will be delivered in July. This seminar will cover SQLCLR and parallelism techniques to help you take performance well beyond the levels that typical tuning Read More... Posted Thursday, June 02, 2011 11:21 AM by Adam Machanic | 0 Comments Filed under: new york, parallelism, Performance, SQLCLR, training

• Two Days of Advanced Performance Techniques - July 14-15, New York City

  I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15. This seminar focuses on achieving "next-level" performance--going beyond that which you can gain via normal tuning methodologies . The vehicles for Read More... Posted Wednesday, May 18, 2011 1:19 PM by Adam Machanic | 5 Comments Filed under: data education, new york, parallelism, Performance, SQLCLR

• 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

• PASS Summit 2010 Post-Conference Seminar on Parallel Processing

  I am honored to have been selected for a second year in a row to present a full-day seminar at the PASS Summit. This year's seminar will be a "post-con", and will be delivered on Friday, November 12 . The title of the seminar is " A Day of Doing Many Read More... Posted Wednesday, August 04, 2010 1:37 PM by Adam Machanic | 1 Comments Filed under: parallel processing, parallelism, PASS, Performance

• PASS Performance Virtual Chapter: Parallelize Your Queries!

  Last month a new PASS Virtual Chapter was introduced, one with a theme that is near and dear to much of what I like to work on: performance . Tomorrow, Tuesday August 3rd at noon Eastern time , the chapter will have its second meeting, and I will be doing Read More... Posted Monday, August 02, 2010 12:51 PM by Adam Machanic | 4 Comments Filed under: parallel processing, parallelism, PASS, Performance, query plans

• 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 | 9 Comments Filed under: COALESCE, ISNULL, nullability, Optimization, Performance

• A Warning to Those Using sys.dm_exec_query_stats

  The sys.dm_exec_query_stats view is one of my favorite DMVs. It has replaced a large chunk of what I used to use SQL Trace for--pulling metrics about what queries are running and how often--and it makes this kind of data collection painless and automatic. Read More... Posted Thursday, April 22, 2010 11:15 PM by Adam Machanic | 10 Comments Filed under: DMVs, monitoring, Performance