Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1608

Re: Inadvertently moving table to a new filegroup? (2005, 2012)

Show all headers | View raw

rja.carnegie@gmail.com wrote:
> On Monday, 4 November 2013 21:49:45 UTC, Erland Sommarskog  wrote:
>> (rja.carnegie@gmail.com) writes:
>>
>>> But, what should I expect to find where a table was newly
>>> indexed or newly created with a clustered index "ON [INDEX]"
>>> as filegroup?
>>
>> In the [INDEX] filegroup.
>>
>> There are no differences between SQL 2005 and SQL 2012
>> in this regard.
>
> Wow.  Was I supposed to know this?  :-(
>
> So this script (as I see) puts the table in "INDEX" although
> I specifically said "PRIMARY".
>
> CREATE TABLE rjac20131105a
>     (
>       i int
>         NOT NULL
>         CONSTRAINT rjac20131105b PRIMARY KEY ON [INDEX]
>     , j int NULL
>     )
> ON [PRIMARY]
> ;
>
> Thank you; I'm glad I got around to asking!

That's right. I just confirmed it by testing your script.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Inadvertently moving table to a new filegroup? (2005, 2012) rja.carnegie@gmail.com - 2013-11-04 07:03 -0800
  Re: Inadvertently moving table to a new filegroup? (2005, 2012) "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2013-11-04 12:52 -0500
  Re: Inadvertently moving table to a new filegroup? (2005, 2012) Erland Sommarskog <esquel@sommarskog.se> - 2013-11-04 22:49 +0100
    Re: Inadvertently moving table to a new filegroup? (2005, 2012) rja.carnegie@gmail.com - 2013-11-05 08:25 -0800
      Re: Inadvertently moving table to a new filegroup? (2005, 2012) "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2013-11-05 15:56 -0500
      Re: Inadvertently moving table to a new filegroup? (2005, 2012) Erland Sommarskog <esquel@sommarskog.se> - 2013-11-07 00:02 +0100

csiph-web