[dba-SQLServer] Specifying index file

John,

Check out file groups.
You can specify one for indexes.

Robert

At 01:00 PM 8/12/2006, you wrote:
>Date: Fri, 11 Aug 2006 16:30:49 -0400
>From: "JWColby" <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] Specifying index file
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <00ad01c6bd85$0a9ed800$657aa8c0 at m6805>
>Content-Type: text/plain;       charset="us-ascii"
>
>Is it possible to specify the file that indexes go into to spread out the
>processing load on the disk drives?  IOW I have 4 drives of 250gb each.  3
>of them have data files that are approaching 100gb.  The fourth is only used
>for the log file which so far is smallish since I am mostly doing bulk
>inserts so far.  I do now need to build some additional fields and add
>indexes on those fields.  Can I specify that the indexes go into a given
>file on a given drive?  Or does SQL Server just put the index right in the
>data files?
>
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com