Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn how to take full advantage of parallelism.
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries.

Blog posts RSS

SQL Server 2016 Public Preview 05 May 2015
It's official, the first public preview of SQL Server 2016 will come this summer. Details are available on the SQL Server Blog:SQL Server 2016 public preview coming this summerIf you want to know more about capabilities of SQL Server 2016 visit the SQL Server 2016 preview page.

SQL Server 2012 T-SQL language enhancements 04 May 2015
Part of my job with Microsoft includes demonstrating SQL Server features. I have a set of five T-SQL scripts that I use for demonstrating SQL Server 2012 language enhancements which I am providing to you below. These scripts were actually tested on SQL Server 2014, which is what I currently use for ...

SQL Server DML Triggers - Tips & Tricks - Part 4 ("Statements that each Trigger should have") 01 May 2015
This is the fourth blog post in the series dedicated to the Tips and Tricks of DML Triggers development.The previous parts can be found here:SQL Server DML Triggers - Tips & Tricks - Part 1 ("Intro" & "Triggers activation order")SQL Server DML Triggers - Tips & Tricks - Part 2 ("Thought ...

How to rename a column when CDC is enabled 30 Apr 2015
I have been recently asked if Always On supports metadata operations on tables. The operation is add, drop and column rename. I said that it was possible. However I was informed that during column rename there was an error about “replication”:Caution: Changing any part of an object name could ...

Tuning slow spatial queries in SQL Server 28 Apr 2015
Even with the right indexes in place, spatial queries in SQL Server are often too slow – but they needn’t be. Two of the most commonly found patterns of query in the spatial world are when you’re looking for the nearest thing to where you are (which I’ve written about before), and when you’re ...