One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works
Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.
Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan while working on Comprehensive Database Performance Health Check.