Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Help resolving duplicates with reindexing logic Expand / Collapse
Author
Message
Posted Tuesday, January 21, 2014 9:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 260, Visits: 469
I would expect no issues if you concentrate solely on IN_ROW_DATA. As I mentioned before, the only option for indexing BLOB type data is with full text indexing, so that won't show up in sys.dm_db_index_physical_stats. Re-organizing BLOB type data would be similar to re-orgnizing a heap, and involve a full export and re-import of the data, and hoping the data lands in the datafile in a contiguous manner. If BLOB fragmentation is a problem, I would move to a Filestream setup, and let the OS handle the fragmentation.
Post #1533210
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse