SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Alok Dwivedi / Changing Table Schema – what goes behind the scenes – Part I / Latest Posts

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

Paul White — Mon, 03 Aug 2009 19:31:12 GMT

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.

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

Ol'SureHand — Mon, 03 Aug 2009 17:07:13 GMT

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 [b]increased[/b] 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!

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

Thomas LeBlanc — Mon, 03 Aug 2009 09:43:45 GMT

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

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

Steve Jones - SSC Editor — Mon, 03 Aug 2009 07:18:18 GMT

The formatting has been corrected.

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

piyush.dhangar — Mon, 03 Aug 2009 04:22:19 GMT

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

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

dwivedialok — Mon, 03 Aug 2009 00:02:04 GMT

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