Viewing 15 posts - 451 through 465 (of 5,678 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. ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 5, 2014 at 2:15 pm
Kuzey (2/5/2014)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 5, 2014 at 10:47 am
Phil Parkin (2/5/2014)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 4, 2014 at 1:16 pm
GilaMonster (2/4/2014)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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.:...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 4, 2014 at 10:33 am
Viewing 15 posts - 451 through 465 (of 5,678 total)