I just can't understand why anyone would want to use Tivoli to do sql backups - I guess you're probably backing up direct to tape? Suggest that sql backups...

ah well if you do the snia stuff you get to learn this stuff. Fibre channel disks and SAS are full duplex, everything else isn't. the main reason sata disks...

if you examine your table/indexes you'll be able to see if the stats are up to date.

I'll always run sp_updatestats on a database every day if I have the window...

you'll have to examine the query plan - there's just too many possible causes here, the most likely being the linked server not doing optimal joins ( if you're unlucky...

oh joy! you can set the date formats within the sql scripts using a set option, you can set the language of your users, or you can just extract...

sometimes post amaze me! rar is pretty good and costs about the same as winzip and works cmd line well. I hope by microsoft compress you don't mean ntfs...

write a query to rebuild the index on it's own - drop it into a query window and either show estimated plan or parse to check for errors. I'd check...

It's a good interesting discussion and I'm pleased with the points raised, also shows me I'm not alone in sufferring san problems. Did I ever mention sata drives ...

I'm not sure you need to worry about setting min memory, in fact I might be inclined to leave it at 0. I've not used std 64bit so it's a...

sql 2005 doesn't appear to be quite so good at deciding if it should recompile a plan, although I've no direct tests to prove this only seeing what happened to...

I had the same sort of problem with 64bit ent. I guess you have, but the critical thing with 64bit is to make sure you've set maximum memory correctly...

I think there's a misunderstanding of how processors are used - btw I'd seriously advise you to disable hyperthreading - regardless of the maxdop setting sql will use all the...

off the top of my head do you make some of them system procs when you create them? ( using sp_ms_marksystemobject )

I did some testing with fulltext vs like statements ; I think you need to read BOL more carefully as I don't seem to remember the fulltext search working quite...

just be wary of using the fast hint as it can create less than optimal cached plans that can really mess performance ( just ask navision users ! ) You'll...