In this article, we will delve into the use cases for SQL Server heaps, scenarios where caution should be exercised, and effective management techniques.
Forwarded Records and Performance – SQL in Sixty Seconds #155
Earlier I wrote a blog post on Forwarded Records and Performance and lots of people liked the blog post. Here is you can read the blog post SQL SERVER – What is Forwarded Records and How to Fix Them?
SQL SERVER – Finding Fragmentation in Forwarded Records
I was asked by my client if there any way to know if there is any way of Finding Fragmentation in Forwarded Records. Let us learn in today’s blog post.
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 – Parallelism for Heap Scan
Every consulting engagement is different and I enjoy interacting with different people while I am working with different experts. Earlier this week, here is what I heard during one of the  Comprehensive Database Performance Health Check engagement about Parallelism for Heap Scan.
SQL SERVER – What is Forwarded Records and How to Fix Them?
During the early year of my career, one of the most popular questions I used to receive was – What is Forwarded Record? I used to find this question very valid as many people yet did not know what is the forwarded record. In most of the cases as time passes by more knowledge is spread amount SQL Server users and the number of questions reduces on a single topic. However, this is something I can’t say is true for Forwarded Records.