Create indexes - own File Group

With help of others on this group, I've been learning and researching
about indexes; an area I neglected.
I see I can specify which filegroup I wish to create an index, which
the default is Primary.
I have more than one drive in my SQL server where I put data and logs
on their own logical raid groups.
My databases are SIMPLE, so they dont use much, if any logs (none as I
understand).
I was thinking of adding an additional file to my database and use it
solely for the indexes.
Any thoughts?

SQL Server 2005 Enterprise x64 SP2
8 disk SAS Raid 1+0 w/ 512mb ram w/ battery backup.
Thanks,
Rob

.

Relevant Pages

  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... Columnist, SQL Server Professional ... > "Daniel Joskovski" wrote in message ... > Yes, you are right, I read that Michelle is writing about logs not log, is ... >>> We have at least two databases on this server in simple recovery ...
    (microsoft.public.sqlserver.server)
  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... I am looking at databases set to simple: ... > Columnist, SQL Server Professional ... >> She says that she has simple recovery and that one of them is tempdb. ... >> Yes, you are right, I read that Michelle is writing about logs not log, ...
    (microsoft.public.sqlserver.server)
  • Re: Suspect
    ... there has been no activity on these databases so there shouldn't be any records in the tran logs to get unsynced. ... SQL server perform system stuff in the background, so even if you didn't do any operations, there are checkpoint and other things going on. ...
    (microsoft.public.sqlserver.server)
  • Re: Create indexes - own File Group
    ... I have more than one drive in my SQL server where I put data and logs ... on their own logical raid groups. ... My databases are SIMPLE, so they dont use much, if any logs (none as I ... your database most definitely DOES use the logs. ...
    (comp.databases.ms-sqlserver)
  • Redirect SQL 2005 data & log files to another partition
    ... When SQL Server 2005 was originally installed by previous IT guy he accepted ... Now all new databases and logs will be ... redirecting after installation. ...
    (microsoft.public.sqlserver.setup)