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....

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...

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!

carpainter69 (9/17/2013)

---

So I'm a little confused on what to do, there are good arguments for and against certs. I took a pay cut to get this job because I...

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...

TravisDBA (9/16/2013)

---

True story Grant. However, IMHO, the higher level certs are also somewhat diminished as well. Particularly, if MS is going to just give up on them because they...

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...

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...

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...

3

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...

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...

That's what I thought. Thanks.

Doing some clean up on user databases...

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...

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...

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?