technically running in single user mode would be quicker as you would not suffer from any contention or user activity. Some commands require single user to run, e.g. rebuilding system...

we haven't answered question 2 fully I note.

This is more tricky and I'm not sure it's actually a very fair question , I have some ideas as it's happened to...

I sometimes like to play devil's advocate, especially with some of the answers as I often feel many sql myths are born this way!!

I have never ever improved or changed...

actually the answer and solution I'd give , having suffered from this problem, is that the result sets returned by this proc vary so much that the cached plan...

you might like to scan through this analysis I did on adding clustered indexes to tables and the size/choice of clustered key

http://grumpyolddba.co.uk/sql2005/working%20with%20indexes%204.mht

the work I did was based upon tables having...

well we can run through the usual supects;

updates stats

updateusage

checkdb

auto close off

auto stats on

rebuild indexes

fragmentation of files and disk system

your application has some poorly indexed tables

plan re-use for diverse result sets

it's...

the reporting capability doesn't work when the database is in 2000 mode - I consider this a disadvantage so chnaging to 9.0 allows better database reporting.

As mentioned it doesn't check...

the microsoft performance dashboard is your custom reports along with dmv stats. I am planning to publish a series of cutom reports onto my web site, hopefully before christmas, these...

virtual memory and memtoleave are totally different matters. the -g startup is not so much a fix as needed in certain circumstances. I've probaly mentioned this before but the real...

I might write something up - I have the partitioning documented as it was using lots of filegroups with multiple files so was quite complex - it also used the...

I had a similar task in sql 2000 with partitioned views - we'd trended our server so knew exactly when it was quiet - it was an international application so...

just an observation here that I often make - databases hould run on server o/s not desktop o/s. Sorry but if you're using w95/98, w2k prof, xp, vista you're not...

without wanting to start a whole new thread within a thread - on-line restores, filegroup restores and backups etc. are a whole different area to partitioned tables. I don't...

yup agreed, although I admit to being biased as tuning is what I do most of. No offence to the posters in this thread but I meet too many people...

ah - what patch levels are you running on o/s and sql server? I had problems with proc cache memory and a problem with ad-hoc queries, you need at least...