Changing Table Schema – what goes behind the scenes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Alok Dwivedi » Changing Table Schema – what goes behind the...

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

Rate Topic

Display Mode

Topic Options

Author

Message

dwivedialok

Posted Monday, August 03, 2009 12:02 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 4:20 AM
Points: 10, Visits: 138

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

Post #763900

piyush.dhangar

Posted Monday, August 03, 2009 4:22 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, December 17, 2012 7:13 AM
Points: 235, Visits: 36

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

Post #763973

Steve Jones - SSC Editor

Posted Monday, August 03, 2009 7:18 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:37 PM
Points: 31,521, Visits: 13,855

The formatting has been corrected.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #764038

Thomas LeBlanc

Posted Monday, August 03, 2009 9:43 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 2,718, Visits: 724

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, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/

Post #764164

Ol'SureHand

Posted Monday, August 03, 2009 5:07 PM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 1:35 AM
Points: 357, Visits: 706

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!

Post #764483

Paul White

Posted Monday, August 03, 2009 7:31 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 10,990, Visits: 10,572

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
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #764509

« Prev Topic | Next Topic »

Permissions