In this article, we will delve into the use cases for SQL Server heaps, scenarios where caution should be exercised, and effective management techniques.
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?
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.
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.
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.