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! The webcast will be delivered LIVE on Saturday, 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 details are as follows:
----------------------------------------

SQL Server 2014 Cardinality Estimator

Session Abstract: Join SQL MCM, SQL MVP & Microsoft Regional Director, Amit Bansal, in this intriguing session that demos 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. This session is not meant for freshers.

----------------------------------------

Date: 4 March 2015, Wednesday

Time: 3.00 pm to 4.00 pm

We look forward to your participation. Please forward this to your friends & colleagues to make them aware of the event. Do spread the word for the SQL Community!

Please note this is an online event & absolutely free.

Thanks & Regards,

SQLMaestros (www.SQLMaestros.com)

Follow us on Facebook at www.facebook.com/SQLMaestros

Follow us on Twitter at www.twitter.com/SQLMaestros

Note: By registering for this free event, you automatically subscribe to our Newsletter. You are free to unsubscribe in case you do not find our newsletters valuable.

Also, did you know about SQL Server Master Classes? - http://www.sqlmaestros.com/sql-server-classes-india/ And are you attending Asia's first SQL Server Conference happening in Bangalore - http://www.sqlservergeeks.com/summit2015