Hi H,

Don't know if you got this sorted, but here's a post on the subject og Builtin\Adimins and some good help/advice from K. Brian Kelley

http://www.sqlservercentral.com/Forums/Topic448888-146-1.aspx

HTH

Great article.

In my last place the Service Ops Manager tried to get something similar set up, with me trying to help it along - we had change control, but this...

Just a question to ask...you're not shrinking the data file after the index rebuild or have autoshrink on?

Yep...got to agree with colin here...

Hi Ebrahim,

Just to confirm...when you migrated did you do all the usual for SQL2000 to SQL2005 migration, ie index rebuilds, update of stats, etc...

BTW, you can access 8GB of RAM...

OK. Guess I'm at a loss on what to suggest. If my understanding is correct, this is all for one DB and you've filled up a number of drives already,...

Hi Markenash,

Are you not having performance problems with this setup? Usually, with such heavily used DBs of such size I would have thought you'd need multiple drives on RAID...

Hi markenash

Just so I understand you right...are you placing the data file for a specific DB that is 100 GB in size on just one pair of drives (via a...

I go with Steve's suggestion, and you won't go far wrong with the Inside SQL Server... books and SQL Server 2005 Administrators Companion as a start.

HTH

Hi Lyn,

With regards to Toni's link and Derived Tables, please read the discussion area too as there are some errors in what was said in the article. Not saying its...

Hi net,

Guess this is a bit late, but came across an old post in my documentation by Paul Randal (and his good lady, Kimberly) that covers some good practice stuff...

I'm afraid I'm with Jeff Moden and Tony Rogerson on this.

I think this is a good example of needing to be careful and understand the implications of what you...

Might be worth looking at this link:

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/17/10-0-plan-cache-flush.aspx

Pretty much covers what GilaMonster has said, incl config and DBCC changes.

Wondering if you've got someone testing code runs and...

I know I'm a bit late in my post...as it references comments made much earlier...

Gives me a bit of confidence to see that I'm using similar techniques to others, such...

And, as if by magic...there's a link in today's SQLServerCentral Headlines - Predeployment I/O Best Practices, by Mike Ruthruff et al 🙂

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

which covers the usefulness...