Level: Intermediate to Advanced
Bradley Ball
Sr. Consultant – Premier Support for Developers
Microsoft
In this session we will break down the changes that were made, why they were made, and example of how SQL 2014 can make your T-SQL life better!
In SQL Server 2014 there are big changes to the Query Optimizer. We get a new cardinality estimator! The way we look at statistics are improved! Heuristics have been improved! Fancy words but what does this mean to you when you're writing T-SQL? Does this mean I need to fear an upgrade to SQL 2014? Want to understand how to use the old or new Optimizer? In this session, we will break down the changes that were made, why they were made, and example of how SQL 2014 can make your T-SQL life better!
You will learn:
- How the Optimizer Changes in SQL Server 2014
- How to use the New or Old Cardinality estimator
- How the Optimizer Rules can be used to your advantage