heap

External Article

Identify and Correct SQL Server Forwarded Records

  • Article

Forwarded records in SQL Server can cause performance issues on heap tables because the record outgrows the page and the database engine uses pointers to reference the data. The best practice is to have a clustered index on every table, however, sometimes there are cases when a clustered index is not needed.

2013-07-09

3,188 reads

Blogs

Latest Update for Undercover Catalogue Powershell Interrogation Script

By

We’ve been hearing of a few people getting errors from the latest Undercover Catalogue,...

How I implemented database migration on AWS using AWS DMS

By

As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions

By

I have heard about many interesting things about programming in Rust and I decided...

Read the latest Blogs

Forums

error in both ssis and ssms - something about losing connections - new error

By stan

hi for about 4 or 5 days now, i've been seeing various connections (to...

The Biggest Database Professional Challenges Today

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Biggest Database Professional Challenges...

How to use Jupyter Notebook in VSCode

By Daniel Calbimonte

Comments posted to this topic are about the item How to use Jupyter Notebook...

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers