Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - Rebuilding the clustered index on a new file group does not move LOB data

Aug 5 2011 10:28PM by Jacob Sebastian   

Just tried to move a 400 GB table into a new file group by rebuilding the clustered index. After the operation, only 200 GB of data was moved to the new file group.

That reminded me that, when rebuilding a clustered index into a new file group only the 'row' data will be moved. Any Large Object Value such as VARCHAR(MAX), XML, TEXT, VARBINARY(MAX) etc, will continue to be in the 'text file group' of the table, which can be configured only at the time of creating the table. To move all the data, including 'text data', the table needs to be re-created on the new file group and data has to be inserted explicitly.

Read More..   [0 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Jacob Sebastian
1 · 100% · 32235
12
 
1
 
12
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

4  Comments  

  • On an related sidenote, you might check out this post by @SQLQueen

    http://sqlblog.com/blogs/kalen_delaney/archive/2011/06/26/where-are-lobs-stored.aspx

    commented on Aug 6 2011 12:43AM
    Nitin
    475 · 0% · 81
  • That is very useful to know. Thank-you for sharing, Jacob!

    commented on Aug 7 2011 9:40AM
    Nakul Vachhrajani
    4 · 36% · 11635
  • Excellent reminder for alumni and great new info for neophytes, Jacob.

    @Nitin... good link to amplify Jacob's thoughtful tip. Thanks for posting it.

    commented on Aug 7 2011 10:33AM
    Jeff Moden
    159 · 1% · 305
  • Thanks Jeff, Nakul and Nitin!

    commented on Aug 7 2011 10:15PM
    Jacob Sebastian
    1 · 100% · 32235

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Rebuilding the clustered index on a new file group does not move LOB data" rated 5 out of 5 by 12 readers
SQL Server - Rebuilding the clustered index on a new file group does not move LOB data , 5.0 out of 5 based on 12 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]