You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo.
You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you.
A database is included by the instance, and a table named EmployeeData is contained by the database.
There is a column named Profile in the EmployeeData table.
Microsoft Office Word 2003 documents are
stored in the column. The space utilized by the Profile column should be cut to the least.
In addition, a
reasonable performance should be maintained to retrieve the content of the column.
Which action will you perform?