Viewing 15 posts - 2,761 through 2,775 (of 5,678 total)
In the OLEDB source you can use a query instead of a tablefeed. Do so, and put your query there.
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
July 18, 2011 at 1:51 pm
Without seeing your sample data, I had to make some assumptions. Don't where clause AFTER you initiate the ROW_NUMBER(). That's what's removing the rows on you. ROW_NUMBER()...
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
July 18, 2011 at 1:50 pm
Brandie Tarvin (7/18/2011)
inevitable.
Drive Failure
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
July 18, 2011 at 12:35 pm
GilaMonster (7/18/2011)
Jeff Moden (7/17/2011)
most accidental DBA's can't get a company to give them 2 weeks paid training leave.
Most companies won't give a 2 day's paid training leave if it's not...
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
July 18, 2011 at 12:32 pm
Jeff Moden (7/17/2011)
Craig Farrell (7/17/2011)
Do you honestly think in 8 hours of training you can get a from scratch IT employee to a working (Junior) DBA?
No... of course not. ...
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
July 17, 2011 at 10:20 pm
Sol, this is screaming homework problem, or interview question.
Please, show us what you've got so far and have worked out on your own, and we'll be happy to try to...
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
July 17, 2011 at 9:14 pm
Jeff Moden (7/17/2011)
Ummm... isn't MCM only two weeks long? What's the difference between what is being proposed and a cert from Microsoft? I was thinking more along the...
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
July 17, 2011 at 9:08 pm
Dumb question, perhaps... but has anyone checked in and made sure you don't have disk failures on either the DW, the SSAS server, or wherever you store your cubes? ...
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
July 17, 2011 at 8:03 pm
This is possible using some xml tricks and the like, but really, it's not what the tool wants to do. It's a reporting/subreport organization, and SQL doesn't do that...
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
July 17, 2011 at 7:48 pm
Revenant (7/17/2011)
bopeavy (7/16/2011)
. . .This is what I got:
About 0 results (0.04 seconds)
Optimized Query! (Truncate All Tables!)
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
July 17, 2011 at 12:42 pm
TravisDBA (7/17/2011)
Maybe you are not suited, or skilled enough, for the position you are looking for. Not saying you are, but consider it.
.
😀
With all due respect, unless I know...
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
July 17, 2011 at 12:12 pm
boxta (7/14/2011)
Available memory during run time seems similar
We have 72 GB on BOTH DW servers, and...
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
July 17, 2011 at 12:05 pm
There's a few problems here. Two of which is going to be seriously problematic:
http://msdn.microsoft.com/en-us/library/ms187067.aspx
INSERT statements add data to the member tables through the partitioned view. The INSERT statements must...
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
July 17, 2011 at 12:01 pm
Brandie Tarvin (7/15/2011)
The best training I've come across is offered by Four Deuce (http://www.fourdeuce.com/training/publicclasses.aspx).
Brandie, my apologies, I didn't mean to completely skip this, and somehow I did. I...
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
July 17, 2011 at 11:43 am
Jeff Moden (7/16/2011)
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
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
July 17, 2011 at 11:29 am
Viewing 15 posts - 2,761 through 2,775 (of 5,678 total)