Posted by rcamarda on 03/12/07 20:03

Greg,
Its a data warehouse. I have tools that could rebuild an empty
database pretty quickly (few hours) and I have daily backups. Builds
take about 2 hours, then its read only the rest of the day.
I use enterprise because of our licensing.

Thanks for the info!
>
> Yes, I've done this and putting your non-clustered indexes in its own group
> can provide an improvement. Especially for rebuilds and the like.
>
> HOWEVER, your database most definitely DOES use the logs. SIMPLE simply
> means that as soon as transactions are complete, the log is truncated so it
> won't grow. But it is definitely being used.
>
> Keep in mind that w/o logs, you seriously hamper your disaster recovery
> options. Since you're running SQL Server Enterprise, that makes me suspect
> this is more than just a little test site.
>
> > SQL Server 2005 Enterprise x64 SP2
> > 8 disk SAS Raid 1+0 w/ 512mb ram w/ battery backup.
> > Thanks,
> > Rob
>
> --
> Greg Moore
> SQL Server DBA Consulting
> Email: sql (at) greenms.com http://www.greenms.com

[Back to original message]