November 18, 2011 at 9:27 am
Note to self: Turn off actual execution plan option before running a million counter loop.
Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
November 18, 2011 at 9:29 am
GabyYYZ (11/18/2011)
Note to self: Turn off actual execution plan option before running a million counter loop.
Oh WHY?, does it crash somewhere :-D.
Edti how to make 2 typpos in1 owrd.
November 18, 2011 at 9:34 am
Ninja's_RGR'us (11/18/2011)
GabyYYZ (11/18/2011)
Note to self: Turn off actual execution plan option before running a million counter loop.Oh WHY?, doesn't it crashe somewhere :-D.
I saw what I had done, killed the transaction, but it was hanging. I HOPE it was writing to my desktop instead of the production server, so killed all connections from my desktop. It wasn't a brief moment of terror...fortunately, it's not a critical table.
Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein
November 18, 2011 at 9:42 am
:w00t::w00t::w00t:
Just passed 70-451. Now I have all exam pre-req's for 88-970 done... just not sure I'm ready for that one yet though.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
November 18, 2011 at 10:30 am
That's just too funny (today's post)!
November 18, 2011 at 10:37 am
Chad Crawford (11/18/2011)
The MCM would be cool, but the $19K price tag is a bit tough to come up with.
What $19 000 price tag? The knowledge exam is $500, the lab exam is $2000. The expensive part is finding good enough training.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 18, 2011 at 10:45 am
GilaMonster (11/18/2011)
Chad Crawford (11/18/2011)
The MCM would be cool, but the $19K price tag is a bit tough to come up with.What $19 000 price tag? The knowledge exam is $500, the lab exam is $2000. The expensive part is finding good enough training.
I think Chad is thinking of the old way, where you had to go to MS for a 3 week training period. Even so, I believe that was $15K. But yep, the cost for the exam is "just" $500.
What might also be a consideration is the testing location... there are just two in all of VA (thankfully one is just 2 miles from work). Not sure where you can do 88-971 (lab) at - it's not showing up on Prometric's site yet. But... I've got a long way to go before I'm ready for either one of these.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
November 18, 2011 at 10:50 am
WayneS (11/18/2011)
GilaMonster (11/18/2011)
Chad Crawford (11/18/2011)
The MCM would be cool, but the $19K price tag is a bit tough to come up with.What $19 000 price tag? The knowledge exam is $500, the lab exam is $2000. The expensive part is finding good enough training.
I think Chad is thinking of the old way, where you had to go to MS for a 3 week training period. Even so, I believe that was $15K.
$18k (for normal people, MVPs got a substantial discount)
But yep, the cost for the exam is "just" $500.
The first exam. There are 2.
What might also be a consideration is the testing location... there are just two in all of VA (thankfully one is just 2 miles from work). Not sure where you can do 88-971 (lab) at - it's not showing up on Prometric's site yet.
There's none in Australia at all iirc. 1 in Africa (the continent of), it's 15 min away from me. Lab exam is at a secure prometric site, I suspect you call and ask.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 18, 2011 at 10:53 am
GilaMonster (11/18/2011)
WayneS (11/18/2011)
GilaMonster (11/18/2011)
Chad Crawford (11/18/2011)
The MCM would be cool, but the $19K price tag is a bit tough to come up with.What $19 000 price tag? The knowledge exam is $500, the lab exam is $2000. The expensive part is finding good enough training.
I think Chad is thinking of the old way, where you had to go to MS for a 3 week training period. Even so, I believe that was $15K.
$18k (for normal people, MVPs got a substantial discount)
But yep, the cost for the exam is "just" $500.
The first exam. There are 2.
What might also be a consideration is the testing location... there are just two in all of VA (thankfully one is just 2 miles from work). Not sure where you can do 88-971 (lab) at - it's not showing up on Prometric's site yet.
There's none in Australia at all iirc. 1 in Africa (the continent of), it's 15 min away from me. Lab exam is at a secure prometric site, I suspect you call and ask.
There's no way that kind of a price tag would ever be worth it to me. Getting a certification isn't going to increase my salary by $20K a year and it'd have to pay for itself in less time than that if I'm going to be getting multiple certifications.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 18, 2011 at 11:01 am
Which is why they changed it from 3 weeks of training and exams to just two exams. Training's now completely up to you to figure out.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 18, 2011 at 11:14 am
Ninja's_RGR'us (11/18/2011)
That's just too funny (today's post)!
Well, I've seen something like what Isabella describe on a development toy server. :laugh:
But I can't imagine it on a proper test server, let alone on a production server. :w00t:
Tom
November 18, 2011 at 11:20 am
L' Eomot Inversé (11/18/2011)
Ninja's_RGR'us (11/18/2011)
That's just too funny (today's post)!Well, I've seen something like what Isabella describe on a development toy server. :laugh:
But I can't imagine it on a proper test server, let alone on a production server. :w00t:
Still funny.
Debug => Where's that damn trigger, no, function? no, recursion in this sp, no, errr yes after 10-60 minutes. 😀
November 18, 2011 at 11:54 am
WayneS (11/18/2011)
:w00t::w00t::w00t:Just passed 70-451. Now I have all exam pre-req's for 88-970 done... just not sure I'm ready for that one yet though.
Well done.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
November 18, 2011 at 12:19 pm
Ah - that is much better. I had a hard enough time with these, but it would be fun to give that a shot.
Viewing 15 posts - 31,876 through 31,890 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply