Using SQL SERVER 2008 R2:
I have a table with 35 million records, one of the field is of datatype VARCHAR(MAX), it has well formed XML stored. Now we have to convert this column to XML data type. Trying 2 possible ways
1) Creating new column with XML data type and updating that column using CAST(XMLFeildname as XML)-- taking a week to do so.
2) Just altering table to change datatype to XML, this is also taking more 1 day.
Please suggest an efficient way to do this faster.
Thanks in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!