Viewing 15 posts - 451 through 465 (of 5,685 total)
Nick-957131 (2/5/2014)
I suppose my question now is can I (should I) use the same dim / facts and subsequent views to support reporting as well as ssas?Thanks again...
Oh, sure. ...
February 5, 2014 at 10:06 pm
At a guess, check your app.startdate field. Also check the join fields from the source, see if they're trying to convert incorrectly to int.
You're going to have to dig...
February 5, 2014 at 2:15 pm
Kuzey (2/5/2014)
February 5, 2014 at 12:00 pm
DTA is... um... I'll find a polite word for it in a moment, hang on.
....
DTA is a best effort guess from an app to try to help you figure out...
February 5, 2014 at 10:58 am
GilaMonster (2/5/2014)
Evil Kraig F (2/5/2014)
I was inaccurate about the intern level though, at least for the administration test. My bad, thanks for clarifying that for me/us.
That quote was actually...
February 5, 2014 at 10:53 am
I personally wouldn't build views for dims/facts over the staging tables. I'd use SCD2 design and create a proper warehouse. The SSAS then just sits on top of...
February 5, 2014 at 10:47 am
Phil Parkin (2/5/2014)
February 5, 2014 at 10:44 am
GilaMonster (2/5/2014)
Who should take this exam?
This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience,...
February 5, 2014 at 10:03 am
cjmorelock (1/31/2014)
I have ~3,500 pipe-delimited text files totaling 300+ GB of data and ~4.8 billion records.
Well, minimally logged operations just went out the window, unless you're going to merge prior...
February 4, 2014 at 4:23 pm
Agree with Jason above. Usually to do this you build a cursor around your temp table, then wrap it in EXEC( @sql) or an sp_executeSQL item. Fetch until...
February 4, 2014 at 2:51 pm
GilaMonster (2/4/2014)
I have no idea how Oracle works.
Well, I only know enough to be dangerous to myself and others, so I'm right there with you.
With a physical RID, SQL has...
February 4, 2014 at 2:29 pm
Short form: You're pivoting your data. You're going to have to call the data multiple times to selectively choose what you're pivoting with.
Now, you could do a temp table...
February 4, 2014 at 2:26 pm
I fear you may have some misconceptions about the expectations of where you're going.
MinhTuCSharper (2/4/2014)
February 4, 2014 at 1:16 pm
GilaMonster (2/4/2014)
February 4, 2014 at 11:56 am
Grant,
My personal concern with that article is bits and pieces like this:
Unlike heap tables, clustered indexes are “living creatures” that move rows around as needed to maintain their properties (i.e.:...
February 4, 2014 at 10:33 am
Viewing 15 posts - 451 through 465 (of 5,685 total)