Tables containg large amounts of data (> 2 GB) need to be spread across
several devices, using sp_placeobject. Note that this procedure affects only
future operations - if a table load of more the 2 GB is to be performed, it
would have to be split into two or more stages.
/* Future inserts will reside on data_seg2 */
sp_placeobject 'data_seg2','invoice'
go
No comments:
Post a Comment