Viewing 15 posts - 2,761 through 2,775 (of 5,685 total)
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()...
July 18, 2011 at 1:50 pm
Brandie Tarvin (7/18/2011)
inevitable.
Drive Failure
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...
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. ...
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...
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...
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? ...
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...
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!)
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...
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...
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...
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...
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)
July 17, 2011 at 11:29 am
Viewing 15 posts - 2,761 through 2,775 (of 5,685 total)