I'm not sure that lock pages is actually a SQL specific property. I always think of this as being more of an o/s property in as much as you can...

so what you are asking is for someone to provide you with a set of basic database/server checks in a word document for you to produce reports on something you...

I don't have that combination of databases, don't use express, but one mthod to move a database across editions/versions is to use snapshot replication. I figure that the database...

no worries - if you want more info drop me an email through the blog or my website

I have a 10Gb lun. I read somewhere it was recommened to use a dedicated lun - failing that did I really want it on a data/log or backup lun?

I do make use of partitioning despite the restrictions, there's a link on my blog to a a large document i produced for a presentation I did which talked...

yes - been there done it. I cover some of the basic concepts in this pdf of a presentation I did

http://www.grumpyolddba.co.uk/gonein60ns/GoneIN60nsWeb.pdf

I can only tell you that I cluster MSDTC, it's best to allocate a dedicated lun to it ( doesn't have to be big ) other than that can't help...

ah well if it's application then it's processes/code that you need to change - if it's system stuff then you need to find a quiet time. I support real 7...

yeah I think I'd have done a rebuild by now, once you spend more than a couple of days it's better to bite the bullit and rebuild. You also get...

well it's a bit of a guess but I'd say the combination of VMware and 2 cores just doesn't provide enough workers.

There's some things you could try: disable parallelism, enable...

not quite sure what you're asking but yes "system" processes can evoke deadlocks - that's why you have to configure your server to avoid such issues. Index rebuilds for instance...

I haven't had to do what you have but i did have problems registering a spn.

I am a domain admin so i added the sql server service account to the...

It'll be making best guesses I suppose - there's always going to be a variation every time I guess.

was a time you had to update sysjobs to avoid this, but sql 2008 doesn't require this. I always make the owner of the jobs sa though - make sure...