this is generally to do with the memtoleave area and indicates fragmentation of memory. Ken Henderson's book Guru's guide to sql server internals has the only real description of what...

I have to be honest I have no basis to claim the UK is better than anywhere else or that discrimination doesn't occur. Before I entered IT I worked in...

yeah I didn't mean to come across wrong - sometimes it proves how difficult it's all become, I'm glad I moved to being a contractor where I don't involved within...

you don't think a user can bring a DW server down with a query ? check out Business Objects !!

you're really wasting time putting zip files to tape as any reasonable tape will compress anyway - been there, done it. If you want compression use Lite Speed, ( and...

Perhaps I should have stated "Devil's Advocate" .. I'm not sure which part of my comments you object to .. I was merely making putting some observations from the other...

The problem I have is the " encourage more women ...... " this is discrimation of the worst kind, and as I remarked in another thread if applied the other...

you should also be able to see the instance name in the services, my 2005 instance service shows with instance name in brackets, so i could register by ip\instancename -...

you can collect mdf/ldf io sttats using fn_virtualfilestats, search the site or google for info on using this. I think I blogged a whole load of code to enable collecting...

strange question!

Production DBA, specialise in application and database tuning ( plus all the hardware etc. and HA , DR & BCP ). Contract. SNIA certified ( fc storage stuff...

This isn't a difficult question, well my understanding of it, it would be much better if you worked through BOL, bought a SQL book or attended a training course. This...

You seem to have listed the available tools, allowing that level of freedom will surly allow the queries from hell to hit your database so good luck.

I would have thought...

you should be able to browse and find a list of the server/instance names. SQLPing will also do the same job. Well documented then, hope this isn't a production system?

your best bet is to recreate the job. I never use sysmaint.exe as it's not reliable to my mind - I always write my code in T SQL within job...

to be honest cursor / loop = row by agonising row operations within triggers would be my worst nightmare for a production database. The overhead of deferred updates is also...