Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.
January 2016 - Posts
Back in 2006, I created a very simple tool called SQLQueryStress . The goal of this tool was to enable the user to test a single query under some form of load -- up to 200 simultaneous threads. I wrote this tool primarily for a book I was working on at Read More...