Home Forums SQL Server 2005 Administering convert ntext to varchar RE: convert ntext to varchar
curious_sqldba
SSC-Dedicated
Points: 36494
More actions
June 9, 2011 at 3:55 pm
#1336757
thanks..let me provide some more details..there is a table more than 100 gb in size with a column ntext which occupies 90% of total table space. Goal is to change data type to varchar and shrink the db..Any ideas?