Google Mail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
microsoft.public.sqlserver.programming
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
creating table on secondery filegroup
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Follow-up To:
Add Cc | Add Follow-up to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers that you hear
 
Roy Goldhammer  
View profile   Translate to Translated (View Original)
 More options 8 Nov, 16:54
Newsgroups: microsoft.public.sqlserver.programming
From: "Roy Goldhammer" <r...@top.com>
Date: Sun, 8 Nov 2009 18:54:32 +0200
Local: Sun 8 Nov 2009 16:54
Subject: creating table on secondery filegroup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
hello there

i have database with two filegroups and for each filegroup there is diffrent
file name

How can I use Select .. into and create new table on secondery filegroup?


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Dan Guzman  
View profile   Translate to Translated (View Original)
 More options 8 Nov, 18:22
Newsgroups: microsoft.public.sqlserver.programming
From: "Dan Guzman" <guzma...@nospam-online.sbcglobal.net>
Date: Sun, 8 Nov 2009 12:22:08 -0600
Local: Sun 8 Nov 2009 18:22
Subject: Re: creating table on secondery filegroup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
SELECT...INTO creates the table on the default filegroup.  You'll need to
mark the secondary filegroup as the default one beforehand:

ALTER DATABASE MyDatabase
    MODIFY FILEGROUP [MySecondaryGroup] DEFAULT;

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Roy Goldhammer" <r...@top.com> wrote in message

news:#77hmQJYKHA.4688@TK2MSFTNGP06.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Kalen Delaney  
View profile   Translate to Translated (View Original)
 More options 8 Nov, 21:00
Newsgroups: microsoft.public.sqlserver.programming
From: "Kalen Delaney" <please_reply_on_newsgro...@domain.com>
Date: Sun, 8 Nov 2009 13:00:28 -0800
Local: Sun 8 Nov 2009 21:00
Subject: Re: creating table on secondery filegroup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

In SQL 2008, you can INSERT into an existing table, using a nested SELECT,
with the same performance as SELECT INTO (in many cases). So you can create
the table on your preferred filegroup, and then copy the rows from the other
table into it. Check the BOL for full details.

--
HTH
Kalen
----------------------------------------
Kalen Delaney
SQL Server MVP
www.SQLServerInternals.com

"Roy Goldhammer" <r...@top.com> wrote in message

news:#77hmQJYKHA.4688@TK2MSFTNGP06.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Roy Goldhammer  
View profile   Translate to Translated (View Original)
 More options 9 Nov, 08:02
Newsgroups: microsoft.public.sqlserver.programming
From: "Roy Goldhammer" <r...@top.com>
Date: Mon, 9 Nov 2009 10:02:38 +0200
Local: Mon 9 Nov 2009 08:02
Subject: Re: creating table on secondery filegroup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Whell Kalen:

I need Select INTO not only for performance. I need it in process which
getting different table each time with different fields.

I'm working on SQL server 2008. Can i solve it on sql server 2008?

"Kalen Delaney" <please_reply_on_newsgro...@domain.com> wrote in message

news:OQoHEaLYKHA.3676@TK2MSFTNGP05.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Balaji  
View profile   Translate to Translated (View Original)
 More options 9 Nov, 10:46
Newsgroups: microsoft.public.sqlserver.programming
From: "Balaji" <tbalajipra...@gmail.com>
Date: Mon, 9 Nov 2009 16:16:42 +0530
Local: Mon 9 Nov 2009 10:46
Subject: Re: creating table on secondery filegroup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Hi Roy,

Yes you can do it in SQL Server 2008 as per Dan suggestion.

Regards, Balaji

"Roy Goldhammer" <r...@top.com> wrote in message

news:uFYvCMRYKHA.4816@TK2MSFTNGP06.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google