sqldba_icon (6/9/2011)
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?
Does the table contain Unicode characters? You need to ensure that you will not encounter data problems by converting to varchar.
I would copy the entire table to a new table and then test the conversion on that new table. Do it a few times to ensure it will work as desired.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events