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 ««12

Alter A Partitioned Table Column DataType. Expand / Collapse
Author
Message
Posted Monday, February 22, 2010 2:03 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 2, 2013 9:39 AM
Points: 329, Visits: 195
Yes Paul this is what i was after,

2008 test page copied from your output.
Slot 0 Column 3 Offset 0x8 Length 5 Length (physical) 5
z = 200.08


2005 test dbcc page shows the following Where is the data?
DROPPED = È                         
z = [NULL]


you should also notice one more thing that the Column order in SqlServer 2005 is 0 based index and 2008 is 1 based index although this is not my question, In Sql Server 2005 where is the data gone?


Regards
Vinay
Post #870726
Posted Monday, February 22, 2010 10:20 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:20 PM
Points: 11,194, Visits: 11,142
I only have SQL Server 2005 SP3 CU7 version 9.0.4273 installed, I'll test it on that later.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #870908
Posted Monday, February 22, 2010 11:07 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:20 PM
Points: 11,194, Visits: 11,142
Confirmed on the 2005 installation I referenced before. BUT this is just a decoding/display problem in DBCC PAGE with type 3 output - the data is there in the page record data, and appears in queries of course. Microsoft don't support or document DBCC PAGE, so you're just going to have to live with it, I'm afraid



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #870925
Posted Wednesday, April 2, 2014 8:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:15 PM
Points: 24, Visits: 20
So the verdict is no data corruption or significant performance issue?

I changed the data type from int to bigint and from image to varbinary(max) on a small partitioning table, it works, can I issue the altering column on a large partitioning table? I am working on sql server 2012 enterprise edition.

Thanks.
Post #1557785
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse