Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.
Recently during the Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.