Viewing 15 posts - 1 through 15 (of 27 total)
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...
if one wants it.. one will justify it.
December 17, 2012 at 7:06 am
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...
if one wants it.. one will justify it.
December 14, 2012 at 9:25 am
To collect: job execution time, job name, success/failure.. very basic stuff.
if one wants it.. one will justify it.
December 14, 2012 at 9:04 am
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...
if one wants it.. one will justify it.
December 14, 2012 at 9:00 am
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...
if one wants it.. one will justify it.
December 14, 2012 at 7:34 am
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...
if one wants it.. one will justify it.
October 16, 2012 at 3:12 pm
This procedure doesn't work. It has a syntax error..
if one wants it.. one will justify it.
June 24, 2011 at 1:07 pm
🙂 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...
if one wants it.. one will justify it.
December 4, 2010 at 8:10 am
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...
if one wants it.. one will justify it.
November 23, 2010 at 2:49 pm
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...
if one wants it.. one will justify it.
November 23, 2010 at 2:29 pm
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,...
if one wants it.. one will justify it.
November 23, 2010 at 2:27 pm
Roy, my apologies. I already started it here.. It is rather gray-area topic..
if one wants it.. one will justify it.
November 23, 2010 at 1:34 pm
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...
if one wants it.. one will justify it.
November 23, 2010 at 1:33 pm
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...
if one wants it.. one will justify it.
April 7, 2010 at 12:12 pm
I agree 100%.. no doubt, but I worry that those "dead" tables in the sysobjects are somehow pulling the performance... reading your link..
if one wants it.. one will justify it.
April 7, 2010 at 11:29 am
Viewing 15 posts - 1 through 15 (of 27 total)