HomeНаука и техникаRelated VideosMore From: SQLMaestros

How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1 (by Amit)

11 ratings | 761 views
In this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS & AVG_RANGE_ROWS. Learn about Amit Bansal’s ultimate video course on SQL Server Performance Tuning: http://bit.ly/abvideocourse Stay Connected with Amit Bansal and subscribe to the exclusive list of his session attendees (conference and pre-cons), class participants & video viewers. You will get just one email in two weeks with good links to continue your learning. http://bit.ly/connectwithab Also, you can join ‘SQLMaestros Champs’ Telegram group and participate in SQL Server discussions. It’s a forum for SQL Server lovers - https://t.me/joinchat/AnAGwxBU1KXORoUR9jD_dw If you work on other technologies in MS Data + AI Stack, join this group: http://www.dataplatformgeeks.com/dpg-mobile/ Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ - http://www.twitter.com/SQLMaestros - https://www.facebook.com/SQLMaestros - Email us: [email protected] Data Platform Summit Asia's largest learning event on AI, Data & Advanced Analytics. https://www.dps10.com/ SQLMaestros Video Courses Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. http://sqlmaestros.com/sql-server-videos-courses/ SQLMaestros Hands-On-Labs Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere. http://hols.SQLMaestros.com Email [email protected] SQLMaestros Learning Kits The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/ SQL Server Health Check If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/ Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 Our Telegram group on mobile http://www.dataplatformgeeks.com/dpg-mobile/ DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development If you wish to speak at DataPlatformGeeks events, fill out this form: http://www.dataplatformgeeks.com/call-speakers-dpg-events/ If you wish to become a Regional Mentor with DataPlatformGeeks, fill out this form: http://www.dataplatformgeeks.com/become-regional-mentor/ Watch all recorded DPG webinars here: www.youtube.com/SQLServerGeeks
Html code for embedding videos on your blog
Text Comments (1)
Tamito (1 year ago)
Thank You Excellent lesson, Perfect explaination !!!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.