They reached out to me to help them fix their SQL Server Performance issues after upgrading. Comprehensive Database Performance Health Check.
One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works
I had a very interesting conversation with one of my clients about Cardinality Estimation for Temp Table vs Table Variable. Let us discuss it today.
Question: How to Find Table Cardinality from the Execution Plan?