Pinellas - Monthly Meeting

Please join us Tuesday, Aug. 18 as Taiob Ali presents:

Title: Think like the Cardinality Estimator

Abstract:
SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code and, in turn, influence the type of physical operations during query execution.

Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data. Do you know how the CE generates these numbers? What happens when you have multiple predicates, range predicates, variable values that are 'NOT KNOWN' to the optimizer, or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using a value that is outside of the histogram range?

In this session, I will show you how CE estimates in all these scenarios, and you will walk out better equipped to tackle those nasty, hard to solve query plans.

Bio:
Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 14 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, including massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning.

Taiob is currently working at “GMO LLC” as Data Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, PASS DBA Virtual Chapter, and organizer of Boston SQL Saturday.

August will once again be online only. We will reevaluate things in late August for September and October.

Link to meeting:
Join Microsoft Teams Meeting
https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZTJhOTI1ZTMtZWE1NS00ZDg2LWI2Y2MtNzhhZDE2MWQyNzUx%40thread.v2/0?context=%7b%22Tid%22%3a%22eeaae40c-0089-41e8-a6e5-3929ae2ce4c3%22%2c%22Oid%22%3a%223c3c2b53-2983-47bf-8332-0b58ae44f8e2%22%7d

Our meetings start at 6:00p.m. for food and networking. About 6:30p.m. we kick off with announcements and then start the presentation, usually about 6:45p.m. Eastern time. (Currently E.D.T.)