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


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

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

From Erland Sommarskog <esquel@sommarskog.se>
Newsgroups comp.databases.ms-sqlserver
Subject Re: Inadvertently moving table to a new filegroup? (2005, 2012)
Date 2013-11-04 22:49 +0100
Organization Erland Sommarskog
Message-ID <XnsA26EE83BAD4BEYazorman@127.0.0.1> (permalink)
References <e786af70-e2b6-40e6-87b0-f6f076ce72d7@googlegroups.com>

Show all headers | View raw


 (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.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | NextPrevious 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