Author |
Topic |
monkeybite
Posting Yak Master
152 Posts |
Posted - 2004-01-30 : 16:49:41
|
Sooooooo, my office manager comes up to me last Friday and says "we need you to pass a MS certification exam so we can retain our partnership". I say, "ok, by when?". She replies, "Friday of next week". So I got signed up for 70-229 that day.So, got the Transcenders that Friday, studied a little bit this week, took the test this morning, and passed with a 738.Whew.~ monkey |
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-30 : 18:16:03
|
Congrats Monkeybite! You going to go for full MCDBA now?--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2004-01-30 : 18:43:29
|
Dunno yet. Oftentimes I seriously question the validity of any type of certifications, as I've seen good and bad DBAs and developers with lots of certifications. However, I don't think it'll hurt me to get one.It was a goal of mine last year to get the MCDBA cert, but I kinda moved on to other pursuits and lost interest.~ m |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-31 : 01:33:35
|
Congrats, man!!Was it tough job to pass thru? I never seen/read those questions.PS I'm not quite sure what exactly I mean by this strange semanticconstruction "seen/read". Hm... there is a subtle difference in them.PPS btw, how you'd solve this thing:create table #t (n int primary key)insert into #tselect 2 union allselect 4 union allselect 5 union allselect 6 union allselect 9Result of a select should be:n1 n2--------2 9 4 6 5 56 49 2 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-31 : 09:07:11
|
Is passing with a 738 on a 70-229 good or not? (Everyone else understood this?)(Do these numbers remind anyone else of CB slang? 10-4 good buddy and all that.)SELECT n, (select top 1 X.n from #t X WHERE X.N >=Y.N ORDER BY X.n DESC) FROM #t Y ORDER BY n |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2004-01-31 : 12:05:44
|
quote: Originally posted by SamC Is passing with a 738 on a 70-229 good or not?
Its 738 out of a possible 1000. Dunno if it's good or not, however the proctor seemed surprised that I passed. She said, "oh, you did very well." I guess that this testing center 1) doesnt give this exam very often, and 2) fail most of the people that do take it.roger, 10-4, over.~ m |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-31 : 14:16:42
|
SamC--create table #t (n int primary key)insert into #tselect 2 union allselect 4 union allselect 5 union allselect 6 union allselect 9SELECT n,(select top 1 X.n from #t X WHERE X.N >=Y.NORDER BY X.n DESC) FROM #t Y ORDER BY ndrop table #tn ----------- ----------- 2 94 95 96 99 9 ???OK, don't worry.Seems it really does not matter whether you seen/read/passed the exam or not. |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-31 : 14:53:20
|
Five 9s. Sometimes five 9s is a good thing. Not now, not here.BTW I forgot.. CONGRATS monkeybiteWhat I'd like to see is a JOIN solution to the problem.Let's see a solution. |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-31 : 15:41:54
|
What does it mean "Let's see a solution." ???Just post it!! |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2004-01-31 : 16:03:25
|
quote: Originally posted by Stoad What does it mean "Let's see a solution." ???Just post it!!
dudes, its saturday... lets work on a solution monday when my time is billable... thanks for the congrats!~ m |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-31 : 21:45:18
|
Lucky monkeybite - managed to avoid addicting to the sql...... |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-31 : 23:10:23
|
[code]SELECT A.n, B.nFROM ( SELECT n, (SELECT COUNT(*) FROM #t A WHERE A.N >= X.n) as RowID FROM #t X) AINNER JOIN ( SELECT n, (SELECT COUNT(*) FROM #t A WHERE A.N <= X.n) as RowID FROM #t X) B ON B.RowID = A.RowIDORDER BY A.n[/code] |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-02-01 : 00:59:47
|
quote: Originally posted by monkeybitedudes, its saturday... lets work on a solution monday when my time is billable...
Just as well we all don't think like that or there would be no SQLTeam(I got 873 by the way )Damian |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-02-01 : 08:28:35
|
SamC--And mine (looks a bit simpler but, in principle, the same):select a.n n1, b.n n2 from #t a inner join #t b on(select count(*) from #t t where t.n<a.n)=(select count(*) from #t t where t.n>b.n)order by 1Damian--873 - nice score! = 9*97 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-02-01 : 08:38:52
|
And surprisingly, both queries generate exactly the same execution plan. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-03 : 11:09:54
|
How much did it cost?And Congrats....what's the 70-229 cover?Brett8-) |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-02-03 : 11:14:38
|
Thinking of taking it Brett?Can it be taken on-line or only in a classroom environment? |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2004-02-03 : 11:22:19
|
The test costs $125 at the testing center I was at. You can only take the exams at MS-certified testing centers.Here's what the 70-229 covers:[url]http://www.microsoft.com/learning/exams/70-229.asp[/url]I'd say that it was pretty hard. The questions can be tricky, sometimes all 5 answers are correct, and you have to choose the best one, or you choose the best 3 out of 6.~ m |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-03 : 11:25:57
|
.....maybe....what's the lowest passing grade?See if I can get the employeer to cough up the dough...Yeah thanks for the link...there a some sample online tests there....Brett8-) |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2004-02-03 : 11:27:27
|
<yoda>700 you receive, pass you will</yoda>~ m |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-02-03 : 11:46:47
|
Where's the online directory of testing centers? |
|
|
Next Page
|