Viewing 15 posts - 1 through 15 (of 87 total)
I think the issue is this dataset is being created from a report model based on a cube. Possibly the cube is asking for MDX, but report builder can't convert....
October 3, 2013 at 11:28 am
I've set up something similar in the past. I set up a subscription which I only wanted to fire if something failed. The way I accomplished this is to create...
October 3, 2013 at 10:13 am
I think I worded my post wrong, because it is exactly parameter sniffing. Once I passed the externals to internals the sproc ran very fast. Thanks!
September 30, 2013 at 9:30 am
September 18, 2013 at 9:12 am
That is definitely an option. The only thing I didn't like about that option is I'm also going to be using this package as a template, and I don't want...
September 17, 2013 at 8:15 am
September 17, 2013 at 8:10 am
Upon further research I've found someone stating the SSIS framework doesn't allow access to the current active package, so my dream of getting the container name via an active object...
September 16, 2013 at 2:14 pm
I'm currently using System::SourceName to capture the failing task name in OnError. Unfortunately it is not available outside of the event handlers, and also does not capture the name of...
September 16, 2013 at 1:24 pm
I agree completely on the non-master certs. I feel they can be valuable for someone with little or no experience as you get at least a bit of a leg...
September 16, 2013 at 7:54 am
A SQL Saturday Speaker shirt from the Sacramento SQL Saturday that just passed about a month ago.
A Quest shirt with 'Kline is Divine'. lol
A RedGate shirt I got at a...
September 20, 2012 at 3:21 pm
Great article. My wife is thinking of switching careers into databases. Probably a lot easier for her having a DBA husband. 😉
One thing I would say though is not sure...
September 11, 2012 at 9:43 am
That's what I thought. Thanks.
Doing some clean up on user databases...
September 26, 2011 at 10:43 am
One thing to worry about when you truncate tables with FKs is what if you can't rebuild the table where the keys you were using will match with the new...
September 13, 2011 at 10:16 am
In my warehouse all the ETL happens in a stage DB where I don't have any FKs, so I just truncate the tables before reloading. I usually am only loading...
September 13, 2011 at 9:49 am
Thanks guys. So DISTINCT in most cases will be faster if it can find an index, but GROUP BY can be faster where no index exists? Generally speaking?
August 5, 2011 at 8:48 am