Cardinality Estimates in Microsoft SQL Server 2014
The way SQL Server estimates cardinality for a query has been updated for SQL 2014. In this session we will discuss why cardinality matters, the differences between the SQL 2014 cardinality and previous versions, and how to evaluate if your queries will benefit after upgrading to SQL 2014.
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, SQL Server MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
LaRock has worked in numerous IT roles over the past 15 years with much of his career focused on database administration, leading to his role as Technical Evangelist for Confio. While at Confio, his research and experience helped to create the initial versions of the software now known as SolarWinds Database Performance Analyzer.
LaRock joined the SolarWinds family through the acquisition of Confio in 2013. His many Microsoft accreditations include SQL Server MVP, MCSM, MCM, MCT, MCITP, MCTS, MCDBA and MCP – whew.
LaRock is the Immediate Past President of the Professional Association for SQL Server (PASS) and is an avid blogger, author, and technical reviewer for numerous books about SQL Server management. He now focuses his time working with customers to help resolve problems and answer questions regarding database performance tuning and virtualization for SQL Server, Oracle, MySQL, SAP, and DB2, making it his mission to give IT and data professionals longer weekends.