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.
SQL SERVER – SQL_NO_CACHE and OPTION (RECOMPILE)
How to retrieve queries, not from the cache for MySQL and SQL Server, we discussed SQL_NO_CACHE and OPTION (RECOMPILE). Let us discuss this.
SQL SERVER – Reducing TempDB Recompilation with Fixed Plan
Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan while working on Comprehensive Database Performance Health Check.
SQL SERVER – Stream Aggregate and Hash Aggregate
Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.
SQL SERVER – OPTION(FAST N) Hint and Performance
I have a very interesting situation while working with SQL Server 2019, which I had not faced before about OPTION(FAST N).
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – Row Goal and Performance
During the recent consulting engagement of SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.