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.
SQL SERVER – Best Practices for Dynamics NAV AX CRM
In the last 3 months, I have done nearly 11 consulting engagement for Dynamics NAV AX CRM while working on Comprehensive Database Performance Health Check.
SQL SERVER – Number of Tables Memory Optimized in TempDB in SQL Server 2019
Let us learn about Memory Optimized in TempDB, which I had earlier discussed with my client Comprehensive Database Performance Health Check.
SQL SERVER – Heaps, Scans and RID Lookup
The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
SQL SERVER – Resolve WAIT_ON_SYNC_STATISTICS_REFRESH Wait Type
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
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.
Why a Filtered Index Is Ignored by Parameterized Queries
Explain why a filtered index is ignored with parameters, inspect plan warnings, and compare literal filters, RECOMPILE, and coverage fixes.