Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changing Table Schema – what goes behind the scenes – Part I Expand / Collapse
Author
Message
Posted Monday, August 03, 2009 12:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 05, 2013 3:42 AM
Points: 10, Visits: 139
Comments posted to this topic are about the item Changing Table Schema – what goes behind the scenes – Part I
Post #763900
Posted Monday, August 03, 2009 4:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC 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
Posted Monday, August 03, 2009 7:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:15 AM
Points: 32,779, Visits: 14,938
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
Posted Monday, August 03, 2009 9:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 10:01 AM
Points: 2,980, Visits: 762
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
Posted Monday, August 03, 2009 5:07 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 5:44 PM
Points: 368, Visits: 714
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
Posted Monday, August 03, 2009 7:31 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:59 AM
Points: 11,168, Visits: 10,931
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 »

Add to briefcase

Permissions Expand / Collapse