Re: Transform/transfer 50Gb - how to do it fast?

B D Jensen (bjorn.d.jensen@xxxxxxxxx) writes:
Thanks for the details about requirements.
But I'm afraid I then must create the newtbl first,
because the old table is in the Primary filegroup.

And as I see there is no way for saying:
select id, func1(col1) into newtbl MYNEWFG from oldtbl.

So I think I have look at unload/load now....

But doesn't ALTER DATABASE permit you to specify a different filegroup as
the default filegroup? You could do that, and then your SELECT INTO tables
should end up there. At least that is what I would expect.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Difference between multiple primary and secondary files..
    ... another 500GB disk to add to the PC) ... If you add another filegroup, you need to move objects, as objects ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Transform/transfer 50Gb - how to do it fast?
    ... But I'm afraid I then must create the newtbl first, ... But doesn't ALTER DATABASE permit you to specify a different filegroup as ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)
  • Re: Problem with database filegroup restructuring in SQL Server?
    ... print 'Move db contents to MDF file' ... database '' because the 'Data Filegroup 1' filegroup is full. ... Please check Books Online, for the exact syntax. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Read-Only table?
    ... filegroup, and then mark the filegroup as readonly. ... CREATE TRIGGER stickout ON readonlytrigger ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Clustered versus Create table on high speed FILEGROUP
    ... > to a new filegroup) or the table structure is on the new filegroup. ... The clustered index is the the table structure, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)