You are here: Re: Create indexes - own File Group « MsSQL Server « IT news, forums, messages
Re: Create indexes - own File Group

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация