The best method to sovle this issue is upgrade to SQL Server 2012, this release introduces a new option that removes a physical constraint on string store file size. For detail information, please refer to the following article:
Configure String Storage for Dimensions and Partitions:
http://technet.microsoft.com/en-us/library/gg471589(SQL.110).aspx

The best method to sovle this issue is upgrade to SQL Server 2012, this release introduces a new option that removes a physical constraint on string store file size. For detail information, please refer to the following article:
Configure String Storage for Dimensions and Partitions:
http://technet.microsoft.com/en-us/library/gg471589(SQL.110).aspx

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.