why do you bother? SQL Server will take the memory it requires to operate and if you still have 1gb of free memory at the end of the day that's...

I think you're being spun a line, I don't have experience of this array controller but i've changed cache and it didn't need an array rebuild - why would it,...

I'd also recommend Idera SQL Diagnostic Manager, I've used it for many years.

I also have a whole range of customised routines I can deploy to sql server, but to be...

this was a real can of worms and I can't remember which rollup you need to apply post sp2 to avoid all this. Personally I never use these type of...

absolutely -  crap apps are always the problem. all the balancing and splitting of files, filegroups, arrays and databases only helps to a certain extent - I'm tuning an...

if plans are different then there will be differences, the amount of resource should not affect a query plan, likewise hyperthreading is probably a red herring. However, that said, not...

this type of post should be in newbies not performance tuning.

the multiple files work in sql2000 and sql2005 - you may want to enable a trace flag, especially in 2000, can't remember which off the top of my head.

You ideally...

what you need to remember is that sql server should not use the page file - therefore on a dedicated box you should set the page file to a fixed...

yes when part of another index - it really depends upon the actual queries, for example working with data where there is a column to indicate active/disabled so queries include...

you generally have to make them dbo of msdb database. Monitoring you can do through web assistant or reporting services or asp.net which allows users with no access to sql...

I'm slightly confused because an identity column is a property of an int or bigint column - guids use newid() property.

if you allow edits on systems without release documentation...

and always check your code actually does what it should when it should.

awe actually has a memory overhead due to paging to get the extended addresses and if you enable the 3gb switch you are restricting the o/s and all out of...

in general guids were one of the worst added features for sql server that allowed people to misuse. Most database's don't need guid's and at 25% the size an int...