Post reply

nvarchar to varchar

  • May 10, 2007 at 1:56 pm

    #117186

    We have many columns in our database defined as nvarchar and we have no need to store unicode data.  I have 2 questions regarding changing the nvarchars to varchar:

    • Would we see the reduced used space from altering them or would we see them after a dbcc updateusage?
    • Would we need to update statistics or would this cause any kind of fragmentation?

    Thanks.

  • May 11, 2007 at 4:24 am

    #705760

    You would see reduced space used, how much depends on the size of the rows and the number of rows in the table. You'll only see the space reclaimed after a full index rebuild of the table though.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply