guids are really bad ideas as keys and you still need constraints to guarantee uniqueness. see my paper about index size which compars a guid to an int on a...

the tables you're talking about are fairly small too - create your secondary indexes on your partitioned tables after population - the size of your current indexes have no real...

partitioning tables is pretty easy and fairly painless, however I would say that you need to plan it carefully and work out exactly what your partitioning criteria will be, then...

oh sorry I meant to apologise if I had sounded contrite - but I stand by my comment, if you have a prod server with user procs in master you...

sorry but best practice says that you should always fully qualify object creation. If objects end up in wrong databases then the correct processes are not in place - for...

used diag manager since 1999 , never found it to be a problem.

cheers - not sure if it's the same KB I remember - doesn't say if it applies to R2, what do you think?

no you use this system proc call afterwards to make a user proc a system proc.

methinks you maybe shouldn't be messing with things you don't understand - otherwise you'd have...

try these: you're looking at multi page allocations as a %age of single and on the buckets you're looking at length of the chains ( high is maybe not...

use sys.dm_os_performance_counters to check your memory usage. make sure max memory is set to maybe 3gb under the maximum memory. you can leave min memory at 0, max memory setting...

not sure if the -g startup applies to 64bit sql, you might want to check.

Backups giving problems - well until a couple of years ago I never thought a backup...

well I'd advise you to disable hyperthreading, you may be suffering from too many threads, I know it sounds strange, but I've seen it a couple of times before.

the -g...

ha! a real tricky one there. I've encountered some of these problems and resolved most of them before. you've been given some wrong advice however. The mem to leave area...

too true, the difference when we moved from 2k to 8k pages ( and thus io size ) with sql 7.0 was absolutley stunning.

even a script would be tricky - sorry, but this sort of problem needs to be resolved in place. I'd need to see the source data and volumes too -...