Database size impact

• kudla

  SSC Enthusiast

  Points: 166

  More actions

  September 22, 2004 at 7:51 am

  #84195

  Hi

   I have a database size which has around 230 tables and around 5 char/varchar columns / table. I need to change these fields into nchar/nvarchar. What would be the impact. Maybe some ballpark figure.

  Is there some way I can get an accurate figure..

  Please help

  Rgds

  Kudla

• Doug Blystone

  Ten Centuries

  Points: 1144

  More actions

  September 22, 2004 at 8:35 am

  #523989

  As a general rule, you can figure about 2 times the size of the original field, * number of rows * number of tables.

  This will ballpark you i think.  Remember, to check DBCC ShowContig after the change to ensure your indexes are not too fragmented.