Speaking at PASS Summit 2020
November 9, 2020
It is a great honor and privilege that I will be speaking at PASS Summit 2020. This is the first time for me to speak at the PASS Summit.
This year PASS Summit is happening virtually. You have the opportunity of learning the latest in Architecture, Data Management, Analytics, and Professional Development. There are over 250 sessions to choose from.
Besides the regular sessions, Microsoft will have a huge presence at the Summit with sessions, data clinic and focus groups. Nice opportunity to network, join in some fun activities, and win prizes.
My session is about ‘Think Like the Cardinality Estimator” on Wednesday, November 11th, at 2 pm EST.
Abstract for my session:
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.
If this topic sounds interesting to you, please join me. Details about my session are here.
There is a great line up of speakers presenting some powerful sessions. Check out the full schedule here.