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.


3,188 reads


Your First Databricks Notebook


On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series....

SQL Clone Works with FILESTREAM


SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...

Fun and profit with UTF-8


When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...

Read the latest Blogs


Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Valentino Sale Location

By ggsneakersw

Landmarc (TriBeCa Valentino Sale Location) - Beyond kid friendly with amazing healthy menu sources...

SQL Deadlock

By 6pravin9@gmail.com

I have Simple SP to Insert Single Record from Application. When I executes it...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers