you're not likely to get anything of any real use from the procedure cache for what you're asking, also be aware of the size of your cache before running...

this level of performance tuning is not simple, as you're discovering. I'm currently investigating a possible upgarde for a production system - I posted asking about fastest servers and there...

an index re-org will not update stats. Auto update stats will also not update all your stats, so if you want to update stats do it after any index operations.

I...

then you'll need to write your own code to capture that info to a table, or run a profiler writing to a table just to audit login/out.

Generally, but I have seen service packs split, do you mean you're downloading service pack 1 ? in which case you shouldn't need a seperate ssms patch but there...

No jobs etc. should not be affected by changing the SA password. It saddens me your previous guy was called a DBA, this isn't the way a professional should work!...

with respect - the original post mentioned C: and D: drives, doesn't sound like a typical SAN.

Apart from which it all really depends upon your make of SAN, the segregation...

I don't wish to be rude here but why not try reading BOL, getting a basic intro to sql server book or even going on a training course.

It saddens me...

it's pretty easy to search through the text of procedures and functions in sql server, but it's possibly safer to search through the source code repository,often it has defined searches.

I'm...

you can call the same proc multiple times - we'd all have issues if we couldn't! If you don't qualify procs then this can cause blocking, you get similar...

depending upon your hardware and the application ( database ) requirements sharing could be very bad as the disk operations require sequential writes for the transaction log, this is why...

I have plans to build a physical cluster ( no virtualisation ) using windows 2008 R2 storage server - this acts essentially as a shared iscsi storage source. You...

can you be specific about what part of the "load" is actually giving issues. Normally there is a visible indication of a bottleneck.

Depending upon your database structure it would be...

I'm sure the majority of responses will be to use SSIS, I'd probably use stored procs.

Linked servers are not the end of the world, for example It's quite possible to...

try '1 jan 1990' as [CustomerDate]

in my view this

create view vw_testing

as

select 1 as NumKey,'fred' as [JimBob],'1 jan 2011' as [TheDate],userid

from dbo.;

the columns which are static show as...