Viewing 15 posts - 151 through 165 (of 342 total)
It was being backed up regularly (once per hour) and was regularly defragged. I don't recall exactly what I was doing to the database but the application accessing the database,...
July 1, 2008 at 12:23 pm
Steve Jones - Editor (6/25/2008)
DO NOT shrink.
What about shrinking the logs? I never shrink my databases but once per week, when I run the maintenance on my databases, my logs...
July 1, 2008 at 10:38 am
For a small number of servers, I use the same username/password for all. It is too much of a pain to keep track of a different password for each server....
June 27, 2008 at 7:22 am
I answered my own question here. With the data flows linked to the next Execute SQL task, nothing ran past the first data flow task. I removed the links from...
June 26, 2008 at 11:43 am
I have always used the Notifications on my jobs to send me a message when the job failed. It seems your setup should be working fine but I'm wondering why...
June 26, 2008 at 11:36 am
TheSQLGuru (6/26/2008)
June 26, 2008 at 10:27 am
One final question and I think I have this thing done. I have it working for one of our three banks as follows:
1. Does the record count in an Execute...
June 25, 2008 at 9:57 am
crever (6/25/2008)
That's almost exactly what I said... whatever...
Sorry, I wasn't seeing the forest for the trees when I read your initial post. I was focused on keeping everything inside the...
June 25, 2008 at 8:34 am
Makes perfect sense. Now I just have to figure out how to make it work - to the books! I'll be back if I can't figure it out.
Thanks!
June 25, 2008 at 8:08 am
AndyD (6/25/2008)
There are also lots of trained DBAs who are disturbingly bad at their job, but that's a slightly different issue.
Interesting point. I am a "trained DBA" and am very...
June 25, 2008 at 7:49 am
So, I will actually have to have two data flow tasks in the control flow? The first to do the rowcount and populate a package scope variable and the second...
June 25, 2008 at 7:36 am
I guess you could say I was one of those who fell into the title 11 years ago. I was hired to do application support but the role changed as...
June 25, 2008 at 7:33 am
How do I add an expression inside the data flow task? It appears I can only add the expression in the control flow of the package and the rowcount transformation...
June 25, 2008 at 7:10 am
Almost but not completely. I actually have three data flow tasks in this package so it seems that if I do a count and then don't proceed if the count...
June 24, 2008 at 1:04 pm
Viewing 15 posts - 151 through 165 (of 342 total)