Changing Table Schema – what goes behind the scenes – Part I

Question

Post reply

Changing Table Schema – what goes behind the scenes – Part I

dwivedialok

SSC Enthusiast

Points: 124
More actions
August 3, 2009 at 12:02 am

#203416

Comments posted to this topic are about the item Changing Table Schema – what goes behind the scenes – Part I

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

piyush.dhangar SSC Veteran Points: 293 More actions · Answer 1

Can this post be made more readable. The code part which contains almost everything is messy and mot understandable.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736478

August 3, 2009 at 7:18 am

#1033629

The formatting has been corrected.

Thomas LeBlanc SSCrazy Eights Points: 8085 More actions · Answer 3

Thanks for putting the time in to explain this. I have now discovered why a particular table got fragmented. Someone added fixed and variable length fields, poulated with default values and made them NOT NULL.

Thanks again,

ThomasLL

Thomas LeBlanc, MVP Data Platform Consultant

Ol'SureHand SSCrazy Points: 2744 More actions · Answer 4

Thank you - wonderful initiative to help us see stuff that may make a real difference in troubleshooting performance issues.

See elsewhere how Hugo Kornelis, armed with this knowledge, helped me solve an issue where a non-indexed heap increased in size after changing a field from CHAR to VARCHAR (instead of decreasing) - that's because the pages were never rebuilt. This article is showing everyone how to analyse this!

Paul White SSC Guru Points: 150468 More actions · Answer 5

There is a very fine line between basing an article on a book (Inside Microsoft SQL Server 2005: The Storage Engine - by Kalen Delaney) and plagiarizing it.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi