[progress Communities] [progress Openedge Abl] Forum Post: Re: Pro2: Data In The Ms Sql...

[Keith Sudbury]

Well you have two issues... one is that you are using the CHAR data type (fixed length) instead of VARCHAR(variable length). The other is that I am pretty sure that sp_spaceused is reporting the block usage and not the contents of the rows. Loading up terabytes of data into both SQL Server and Oracle I have never seen the supposed extra space usage required. This is of course using the proper data types and without any of the shadow columns that dataserver requires.

Continue reading...