kalen Delaney wrote some of the best consise books on indexing prior to sql 2005. From sql2005 onwards you seem to need more and more books just to pick the...

my understanding is that usually the offset is better for all windows partitions. You should check with your storage vendor. windows 2008 no longer needs this.

run my rdl files and see how the memory is being used ( it's easier in a picture ) You should really get to sp2 on w2k3 and there are...

sorry ! sp_updatestats used to update all stats regardless in sql 2000, in SQL2005 it only updates stats "it thinks" needs updating - doesn't mean it's right.

so if you examine...

there a series of posts which I did here http://www.grumpyolddba.co.uk/sql2005/sql2005.htm

I don't actually have anything which directly relates to your question, I just did a presentation on indexes but again...

there's some stuff which may help here http://www.grumpyolddba.co.uk/monitoring/monitoring.htm

and I have quite a lot of stuff on my blog but it takes a while to find - blog link on my...

I wouldn't have thought so, but set options in connections strings can do strange things - you can usually capture the set options with profiler when the connection is established....

it mentioned file copies and open files, by default windows install is for a file server, you have to configure specifically for an app server. It's a bit of large...

never use maint plans myself - always self code. Could be you've ticked the box which is/was fix problems if found - this always used to give problems in 7.0...

that's the point - it changed from 2000 to 2005. To update ALL stats regardless you must run update statistics against each table not sp_updatestats. If you start altering...

you may have different set options in place from ado, most likely, which means the code runs differently. Make sure you've compiled the proc with ansi nulls and quoted identifier...

but none of this directly relates to issues with agent worker threads which have little to do with the actual user connections.

If you have hyperthreading enabled you should turn it...

Generally it's unlikely to make much difference, splitting to two raids would probably degrade performance I'd guess. I'd migrate the database to multiple files ( not filegroups ) to increase...

I'm interested in where the figure of 80 came from? a hit ratio I can follow but a counter of reads would be hardware specific. I have a sql2k box...

actually make sure your hba, nic and array controller drivers are bang up to date and configutred correctly