Its a pitty that every second DBA must re-create a wheel for very common things: I want to see how my job is performing for the last 6 months.. I...

The beauty of the MDW in SQL Server 2008 is that it creates the containers, database, collecting jobs for you. Problem is: very little to none doucmentaion that I...

To collect: job execution time, job name, success/failure.. very basic stuff.

Farely doing so. However, I am not new to either data-warehousing, marts, etc.. specially star-schemas.

I setup the new MDW. It created a whole bunch of collecting jobs. There is...

Folks,

I am trying to build a SQL Server jobs historical warehouse. This is to run reports to see how a certain jobs are peperforming over few months on a...

one file could be a lot better option but then I think I will get more flexibility if I will create several.

... and yes.. I am working...

This procedure doesn't work. It has a syntax error..

🙂 interesting.. this will take me twice as long. I run out of patience and just said to devs to not send this crap any more. Instead we are getting...

that does look like something worth looking at. I knew that vbscript had issues with large files. Now with X64 bit windows things may be different. Anyone tried the large...

GSquared, if I had a quarter for every bad developer... I wouldn't be posting this. I loaded giga-s of tabular data into the SQL Server in the past and I...

GSquared, I said that many times.. now I am told that it brings only negativity.. 🙂 So.. stop being negative or I will let my boss read this thread 🙂

Roy,...

Roy, my apologies. I already started it here.. It is rather gray-area topic..

Jerry, thanks for kind words, but the transaction log file has nothing to do with it.. Increasing pocket size will slow down everything including this process as well...

It is...

Cool beans folks! Thanks so much for your help. I just have to do some more reading on this I guess.. Still it was really easy in 2K over all...

I agree 100%.. no doubt, but I worry that those "dead" tables in the sysobjects are somehow pulling the performance... reading your link..