• chrs-513176 (11/17/2010)


    I was thinking along the same path, although I thought it still was a good question because I did learn something new.

    I had already learned the differance between Defined Row size and Storage Row size during my upgrading SQL server skills course.

    The differance actually saved us from purchasing a recomended unecessary upgrade for a location.

    They were having issues with maxing out the Network during the transfer of a large table that was filled with a lot of un-normalized data. Since the bottle-neck was not in the Disk-IO or the amount of storage being used compression would not have helped. Instead we normalized the data that was being requested from ten large tables joined by an excel formula to one table of just the data being requested using a view.

    Creating the view cost less than SQL 2008 Enterprise.