I just saw that thread posted by Paul. With Kim out of town, he's in a cranky mood. Never a good day to argue with, but I think this week...

You have a good point, but I think you're coding around a very unlikely possibility. There is literally thousands of scripts, including system scripts in SQL Server that contain

IN ('master',...

Ha! I'm far from 100% on the QOD. I'd like to say I'm testing wrong answers, which I do at times, but rarely. I tend to just give it the...

I think it's a cultural issue. There is a different kind of excitement at the US conferences from what I've heard.

You can always submit to speak. I know that doesn't...

I won't be at the PASS Conference, but Brad will go to represent Red Gate. I go to the UK next weekend and no desire for another long flight in...

Gianluca Sartori (3/12/2010)

---

Where I'm currently working we have a coffe machine, but we're not even allowed to get a coffee and drink it there, we have to go back to...

Now that's a way too relax! Not sure it would help me get home on time though...

http://www.amazon.com/Server-Query-Performance-Tuning-Distilled/dp/1430219025/ref=sr_1_1?ie=UTF8&s=books&qid=1237206053&sr=8-1

There should be a log file for SP4 (sqlstp.log or something, sort by recent files in /Windows). Check that more for more details. This is usually some error in starting...

YSLGuru,

I think you're on the right track, and despite the posts, it seems that you understand the issue. Don't worry about getting some good feelings from others. Go with your...

It looks like some sort of weighted average. Not sure. The denominator label throws me off. You really have

sum (count * average) / sum ( count)

I think you need to run this through a spell checker since I'm not completely sure what you mean here.

Can you run your stored procedures through SSMS? I'm not...

I like the solution above. It's much easier to work with this data inside SQL Server than it is during the import.

Jason,

Did you mean option 1? I tend to agree with you, though I might run a rollup each day looking for an overall look of what happened with jobs.

I'm confused as to why you are trying to execute step by step. I think that perhaps some of the structure of the package is getting lost by executing a...