SQL Special Webcast Event, March 4, 2015, 3 PM to 4 PM
Event Details:
Event Type | Free Webcast Note: The event is strictly for working professionals |
Session Title | SQL Server 2014 Cardinality Estimator |
Session Overview | The cardinality estimation logic, called the cardinality estimator, is re-designed in SQL Server 2014 to improve the quality of query plans, and therefore to improve query performance. The new cardinality estimator incorporates assumptions and algorithms that work well on modern OLTP and data warehousing workloads. It is based on in-depth cardinality estimation research on modern workloads, and our learnings over the past 15 years of improving the SQL Server cardinality estimator. Feedback from customers shows that while most queries will benefit from the change or remain unchanged, a small number might show regressions compared to the previous cardinality estimator. In this session you will watch the new cardinality estimator in action!. This webcast will be delivered LIVE on Wednesday, 4 March using Live Meeting from 3.00 pm to 4 pm IST. This session is a free community event. Register now to block your seat! |
Session Abstract | Join SQL MCM, SQL MVP & Microsoft Regional Director, Amit Bansal, in this intriguing session that demo’s the new Cardinality Estimator in SQL Server 2014. Learn how calculations and assumptions are made inside the black box using statistics. Watch the old and the new cardinality estimator in action, you will love it! |
Target Audience | SQL Server Database Administrators, SQL Server Developers, SQL Server Architects |
Prerequisites | You need to have at least 1 year of working experience with SQL Server and should know the basics of Querying. |
Dates & Time | 4 March 2015, 3 PM to 4 PM IST |
Tool(s) | LiveMeeting |
How does it work? | Requirements:
Instructions:
Fundamentals:
|
Speaker | Amit R S Bansal (SQL MCM, SQL MVP, Microsoft Regional Director) |
Registration | Click here to register (Register only if you are a working professional) |