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!

Ver todos los episodios