April 13, 2012 at 1:53 pm
Hi,
1. How to move one filegroup content to the other filegroup using syntax? Is this just a simple alter statement?
2. In a datafile group, there are 4 files which are set as - default.
Now once the data starts flowing in to this filegroup how this will be used /filled in the files? Does this happen like parallel insertion of the records in each file or first it complete entering the data in first file followed by moving into other files?
Thanks.
April 13, 2012 at 1:55 pm
1) Rebuilds the indexes that you want to move and specify ON <desired filegroup>, and remember that the clustered index is the table.
2) Read up on proportional fill.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 13, 2012 at 1:58 pm
Thanks Gail.
One more request, could you please elaborate a bit against point no.1?
Thanks.
April 13, 2012 at 2:04 pm
What elaboration do you need?
If you want syntax, look up CREATE INDEX with the ON clause and the DROP_EXISTING clause.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 13, 2012 at 2:30 pm
Also, if the tables you are moving have BLOB datatypes, you will need to recreate the tables in the new filegroup in order to release the space from the first filegroup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply