Joe is a SQL Server Consultant specializing in seriously difficult performance issues. Root cause analysis of complex and vexing problems. Quick non-disruptive fixes for production systems when possible, and in-place re-architecture to correct deeply ingrained flaws when required. Prefers to be on the project from the beginning, but usually called as firefighter of last resort.
SQL ExecStats by Joe for automating SQL XML plan analysis, cross-referencing index usage to execution plans. He has models for predicting SQL Server performance early in the design phase, and taking the guess work out of performance tuning.
He has built a more complete model than the SQL Server internal cost based query optimizer, including processor and system ar
Extended Session (90 minutes):