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.
Online Recorded Class – SQL Server Performance Tuning Practical Workshop
There is a limitation of how many classes, I can deliver in person. That is why I have converted my most popular training to Online Recorded Class.
SQL SERVER 2019 – How to Turn On or Enable Instant File Initialization?
In this blog, we would see the current setting of instant file initialization and how to make the modification. Let us learn about it today.
SQL SERVER – Performance and Recompiling Query – Summary
I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.
SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.