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....
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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!
-------------------------------------------------------------------------------------------------
My SQL Server Blog
September 30, 2013 at 9:30 am
carpainter69 (9/17/2013)
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
September 17, 2013 at 8:15 am
TravisDBA (9/16/2013)
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
September 16, 2013 at 7:54 am
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
September 11, 2012 at 9:43 am
That's what I thought. Thanks.
Doing some clean up on user databases...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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...
-------------------------------------------------------------------------------------------------
My SQL Server Blog
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?
-------------------------------------------------------------------------------------------------
My SQL Server Blog
August 5, 2011 at 8:48 am
Viewing 15 posts - 1 through 15 (of 87 total)