Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!
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.