Forwarded Records and Performance - SQL in Sixty Seconds 155

Let us learn how forwarded records negatively impact the performance and how it can be fixed.

0:00 Intro
0:15 Forwarded Records
0:30 Demo: Forwarded Records
1:26 Wisdom
1:39 Fix Performance Issues
1:57 Summary

#SQLServer #PerformanceTuning #SQLAuthority

[diegoalexander]

It's a good video, thanks for sharing your knowledge

[savananjaria]

I was unable to decide if I should focus more on the topic or the way it is presented as both of them are equally excellent. So, I watched it twice. Once to understand the topic and the 2nd time to learn the effects and presentation skills 👌

[mauroldanr]

Is there any negative impacts rebuilding a table in live environment? regarding with indexes, etc

[allenshepard]

Watched video three times as seeing you dressed two different ways is amazing.
Yes, forward records from updated tables are a problem. Your script runs faster than mine so thank you.
Question - does this happen in indexes ? Page split on leaf table. My guess is no but I do not have a reason why.

[mukundraj]

Hi Pinal
Mine is showing 23 Pages

create table HeapTable (Col1 nvarchar(150))
GO
Insert into HeapTable values ('SmallString')
GO 5000

Table_Name
HeapTable 0 23