seekwell_fan (1/24/2009)

---

Hi, guys!

Thank you all for your advises. I appreciated all of them

I can't answer to each of you, so I would like to answer only for some common ideas.

First,...

the certification won't harm as it shows a good attitude and willingness to learn, but in IT experience counts for a whole lot more.

go for it, but you may have...

Cathy DePaolo (1/23/2009)

---

One last thing that I should note is the link to the article I keep referring to. The article describes pre-production tasks and can be found here:

http://www.sqlservercentral.com/articles/Administration/64732/....

with the sizes you quote I would definitely split up the reindexing job, one for the large table, one for the others. As an estimate a 50Gb log as a...

Cathy, I think you need to tailor you maintenance to your circumstances, It's always a problem when you have a large database consisting almost entirely of a single table. You...

Is it just me or it seems strange why these CU1 fixes were not included in SP3 in the first place?

quote]

A service Pack is a fixed point where microsoft guarantee...

Perry, I'll find out the exact versions and LUN configuration if only because I want to know and am a little worried we might be missing a trick here.

I would...

thanks for the feedback.

Please don't keep shrinking the file, it will fragment the database each time you do, also auto shrink could kick in at busy times, last thing you...

thanks for the replies.

The VM would have had either 2 or 4 cores (cannot remember for sure) with maxdop = 0, so parallel queries would have been possible.

We are using...

Grant Fritchey (1/21/2009)

---

The overwhelming majority of our production systems are 2000. We're starting an initiative this year to get them upgraded to 2008 over the next two years because, in...

a long thread here but I don't think this has been asked\answered -

the article mentioned that VM streamlines the DR process, but for that to be fully true the...

I think you will find SQL 2000 is more popular than you think, there are still a lot of 2000 instances out there.

Almost everyone installing from new though will be...

you have told the reindex job to only use 10% of each page when it reorganises the data, hence you have loads of wasted space within each page, so the...

EdVassie (1/19/2009)

---

The msdb database often becomes very important, particularly where a site makes extensive use of SSIS or DTS. Whereever this is the case, msdb should be treated...

Agree with the others the limiting factor is the load the databases put on the server. So you need to baseline your performance stats and every time you add a...