first off you should have all the rights you need to stop and start services - as you don't need to reboot - a service stop and start does the...

what account are you using to run the service? and have/are you making chnages through config manager and not services. Not sure about SP1 but don't think it's relevent here.

check you have all network cards running full duplex, not auto. Sounds like ad problems to me.

Paul randal's blog has details on this.

I think it's very difficult to judge your skill set against others, and as I often say the product is so wide that you may have no experience of some...

this may help http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/06/configuring-windows-2003-x64-for-sql-server.aspx

x64 can be a bit tricky!!

I think that with a product like SQL Server it's always easy to find questions someone can't answer. Persoanlly when interviewing I have some simple questions which a candidate must...

Agreed, don't confuse filegroups and files. You can gain performance by creating files within a filegroup, usually 1 per core, filegroups for performance should be on seperate physical spindles ...

actually allowing 1 gb for sql server on a 2gb server does not allow 1gb for o/s. I'd recommend 4gb ram with no special memory settings for sql server...

well put Matt - there is some sort of mystique about SAN's , especially put about by certain vendors on how suddenly the performance of disk arrays is different on...

yup the SAS drives are coming along now, as I've already posted elsewhere don't muddle bandwidth with io performance - it takes a lot of sql server io to swamp...

it's not easy to always post code - there is client/employer confidentiality and do you really want to read a couple of hundred lines of code anyway?

Inline functions are a...

beware of tests showing disk performance - for sql server the most important factor is io/sec and this is largely a factor of rotational speed. You need to do the...

I wonder what search resurected this project .. sorry thread!! If I ever try searching for a thread from last year I can never find it.

it's a bit black box - I did two levels of snia training in fibre channel architecture to help me understand http://www.snia.org - in the uk there's...