They reached out to me to help them fix their SQL Server Performance issues after upgrading. Comprehensive Database Performance Health Check.
SQL SERVER – Simple Explanation FORCE DEFAULT CARDINALITY ESTIMATION
One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works
SQL SERVER – Temp Table vs Table Variable – Cardinality Estimation
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.
How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213
Question: How to Find Table Cardinality from the Execution Plan?