About Show #283
Richard chats with former PFE Joe Sack about his work helping queries go faster in SQL Server. Joe talks about his techniques for figuring out what to fix as well as how to fix it, starting with studying wait statistics in dynamic management views - SQL Server knows what it's waiting for! From there the conversation digs into the ways that SQL Server fools itself to perform badly, including cardinality estimate issues and other problems with statistics. Joe also looks at the potential of column store indexes in SQL 2012 - still new cool stuff to come in SQL Server!
Joe Sack is a Principal Consultant, author and trainer at SQLskills.com. Prior to joining SQLskills, Joe worked at Microsoft as a Premier Field Engineer for large enterprise environments. He is a SQL Server Microsoft Certified Master (MCM) for versions 2005 & 2008. He was also the program manager for the SQL Server MCM Program from 2009 to 2011. He has written multiple books, articles and whitepapers including SQL Server 2008 Transact-SQL Recipes (Apress, 2008) and most recently, two new Microsoft SQL Server 2012 AlwaysOn Architecture Guides. His first instructional video course "SQL Server: Transact-SQL Basic Data Retrieval" was recently published on Pluralsight.com.