As you are planning for more updates it would be good to keep in mind the following datatypes in SQL Server are no longer in use/recommended, and/or will be depreciated.

  • datetime
  • smalldatetime
  • ntext
  • text
  • image


In fact, replacing all ntext with nvarchar(MAX) will yield a smaller faster database in most cases.

http://msdn.microsoft.com/en-us/library/ms187993.aspx
http://msdn.microsoft.com/en-us/library/ms187819.aspx