heap

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

P2 Puts Easy, Flexible Project Tracking Tools In Your Hands

By

Improve your team's workflow and productivity with these project tracking blocks.

Daily Coping 22 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Read the latest Blogs

Forums

SSDT Data Corruption

By steve.burton 78514

Hi, We have a problem with a SSDT Data Flow task corrupting data. For...

Cannot look at SQL Agent jobs, get error

By Summer90

We have inherited a SQL 2012 installation and when I attempt to open any...

Adding Comma , after IIF

By niteowl

So guys, I want the output value be like Opening Date, Closing Date Lets...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers