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:

  1. A PC/Laptop
  2. A microphone & a pair of headphones (or) speakers
  3. Microsoft Live Meeting client -> Free Download

Instructions:

  1. Make sure Microsoft Live Meeting is installed on your computer/laptop. (Download Now)
  2. Make sure the microphone & speakers/headset are working.
  3. Make sure your Internet connection is working.
  4. Start Live Meeting client (Click on Start -> Program -> Microsoft Office Live Meeting 2007 -> Microsoft Office Live Meeting 2007)
  5. Copy and paste the Meeting ID, Entry Code & Location
  6. Click on Join
  7. Enter your name, Email ID & Company Name
  8. Click on Continue
  9. You have now joined the live meeting session !

Fundamentals:

  1. Please keep your Microphone muted when you are not speaking
  2. One person speaks at a time. Let the other person finish before you ask your question
  3. Live Meeting client is a simple tool, yet to learn the basics of Live Meeting client user interface, click here.
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)

 
 

Register Now
 
Do you want to be notified of future classes and events? Click here