September 3, 2013 at 6:44 am
paul.knibbs (9/3/2013)
Jan Van der Eecken (9/2/2013)
Not so sure about that. Yes, 64 bit Windows machines are able to run 32 bit versions of the same software, but they have to thunk down to 32 bit mode, so that's an additional overhead.
It's not quite the same situation as we had on the Windows 9x series, where 32-bit applications were having to thunk down into the 16-bit, non-reentrant core components all the time--the translation from 64-bit to 32-bit is considerably lighter and less intrusive. Microsoft claim that a 32-bit application running under WOW64 performs pretty much the same as it would on a 32-bit OS running on the same hardware, and I've never seen anything that would suggest that's wrong.
The main issue with 32-bit apps is their limitation to 4Gb of RAM, but note that this is actually better than the same 32-bit app running on a 32-bit system, which would be limited to 2Gb due to the other half of the memory map being reserved for system use. Still, if you're intending to do some serious SQL work on the machine, that limitation could become an issue!
Generally, on 32 bit, no single process can use more than 2GB from what I remember.
I remember doing some G/L dumps for the auditors, and having to split them apart to import into Access.
If you start building cubes on the same machine with SQL, it's not too hard to start getting SQL, SSAS, and the OS to start pushing RAM around and start paging.
September 3, 2013 at 6:51 am
For what it's worth I put my comments and vote in for the MCM. It's interesting because I was going to try to complete my MCSE:Data Platform for 2012 at the PASS Summit in a month because I was thinking about possibly attempting the MCM next year, probably would have failed, but was thinking about it. Now I don't need to spend the time or money on the 2 2012 exams that are left to pass at the Summit. I'd bet there were quite a few people just waiting for the 2012 MCM to be available.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 3, 2013 at 7:26 am
Jack Corbett (9/3/2013)
For what it's worth I put my comments and vote in for the MCM. It's interesting because I was going to try to complete my MCSE:Data Platform for 2012 at the PASS Summit in a month because I was thinking about possibly attempting the MCM next year, probably would have failed, but was thinking about it. Now I don't need to spend the time or money on the 2 2012 exams that are left to pass at the Summit. I'd bet there were quite a few people just waiting for the 2012 MCM to be available.
Yes, yes there were plenty of people just waiting for that 2012 lab exam to be published.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2013 at 8:29 am
Greg Edwards-268690 (9/3/2013)
Generally, on 32 bit, no single process can use more than 2GB from what I remember.
Depends. If the app has the LARGE_ADDRESS_AWARE flag set in its header, and you use the /3Gb switch in your BOOT.INI, then it can use 3Gb--the uppermost gigabyte is always reserved for the system no matter what. Note that the 32-bit app would also need to be LARGE_ADDRESS_AWARE before it could use 4Gb on a 64-bit system. I would assume SQL server has that flag set--would be a bit strange if it didn't!
September 3, 2013 at 8:55 am
GilaMonster (9/2/2013)
SQLRNNR (9/2/2013)
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Just ....Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a Friday night, right before a USA long weekend.
At least I no longer have to worry about budgeting for the upgrade exam.
That's just sad.
For those that haven't seen it yet
Connect Item on the Retirement of MCM
And a lengthy summary of the whole thing
http://jasonbrimhall.info/2013/09/02/rare-species-extinction-and-the-mcm/
and I sent a write-up on the situation to Steve. When, where, how and if it gets published remains to be seen.
Gail's looks good. I'll edit and get it out.
Another note: http://ozar.me/2013/09/the-sqlmcm-is-dead-experiments-go-on/
September 3, 2013 at 9:00 am
ChrisM@Work (9/3/2013)
Thanks Tom. I voted in favour of keeping the program.
It's the only MS cert I know of for sure which can't be cheated.
Yet. It can't be cheated yet. At some point, as more and more people get certified, every system is subject to some gaming unless it constantly evolves. I suspect the MCM only has a limited set of scenarios, 15-20, maybe a few more. At some point a candidate can memorize all the ideas in there and go through.
The old Novell tests, which were adaptive, meaning you answer right, you get harder questions, wrong you get easier ones, with a large pool, were gamed. All others are gamed at some point.
Ultimately I think we need a large pool of scenarios, in the hundreds, with practical clicks someone makes and submits a test at the end, similar to the MCM. I'd rather see them grading us and noting our skills in areas, not generically on the platform. Even now, there is at least one MCM that doesn't necessarily claim to be an admin genius or guru. This person studied hard for a year, took classes, and passed, but didn't have the 10 years of SQL Server admin work.
I have some thoughts here, but I need to get organized.
September 3, 2013 at 9:13 am
I just wrote and submitted a 400 word editorial for Simple-Talk on MCM.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 3, 2013 at 9:15 am
Steve Jones - SSC Editor (9/3/2013)
... but didn't have the 10 years of SQL Server admin work.
I don't.
I have about 8 years experience designing, developing and tuning SQL Server. 0 years experience as an administrator.
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
September 3, 2013 at 9:35 am
GilaMonster (9/3/2013)
Steve Jones - SSC Editor (9/3/2013)
... but didn't have the 10 years of SQL Server admin work.I don't.
I have about 8 years experience developing and tuning SQL Server. 0 years experience as an administrator.
And we'd all rather have you caring for a data than many people out there actually doing it.:cool:
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 3, 2013 at 9:53 am
GilaMonster (9/3/2013)
Steve Jones - SSC Editor (9/3/2013)
... but didn't have the 10 years of SQL Server admin work.I don't.
I have about 8 years experience designing, developing and tuning SQL Server. 0 years experience as an administrator.
I'd argue that's not quite true. Perhaps that hasn't been your title or contract, but it seems you've done a lot of us, and you answer questions on this. The person I know doesn't really deal with SQL Server much as an OLTP platform. This is a BI person almost exclusively.
September 3, 2013 at 9:59 am
Jan Van der Eecken (9/3/2013)
SQLRNNR (9/2/2013)
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Just ....Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a Friday night, right before a USA long weekend.
At least I no longer have to worry about budgeting for the upgrade exam.
That's just sad.
For those that haven't seen it yet
Connect Item on the Retirement of MCM
And a lengthy summary of the whole thing
http://jasonbrimhall.info/2013/09/02/rare-species-extinction-and-the-mcm/
Tried to vote for it, but then I get
"The system has encountered an unexpected error. We apologize for the inconvenience. The issue will be addressed as quickly as possible."
I wish that meant the issue with the retirement and not with the server.
I had plans for the MCM, but was taking it slow so I could work alongside some coworkers. Faced with one month to close out what is remaining and jump in, I don't think I'll make it. I'm very sad and disappointed. Thanks for posting the information here, I've read through as many of the links as I've been able to and voted on the connect item. Please post updates that I might not see and suggestions on other places I can make my voice heard that might make a difference.
Chad
September 3, 2013 at 10:45 am
GilaMonster (9/2/2013)
SQLRNNR (9/2/2013)
Pins and needles seeing the strike-through on your MCM in the signature.I'll remove the strikeout in a week or two. Just making a point.
Good. I cringed also when seeing it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 3, 2013 at 11:03 am
GilaMonster (9/2/2013)
SQLRNNR (9/2/2013)
Pins and needles seeing the strike-through on your MCM in the signature.I'll remove the strikeout in a week or two. Just making a point.
Like normal, Gail, you made your point very succinctly. Like many of your posts, you made me think. Well, what I read with this one is just plain sad. Any time a high-level certification is retired or killed, it just dumbs things down. I would post a reply on the MS Connect site, but I honestly don't think it would do any good.
September 3, 2013 at 3:00 pm
Ed Wagner (9/3/2013)
GilaMonster (9/2/2013)
SQLRNNR (9/2/2013)
Pins and needles seeing the strike-through on your MCM in the signature.I'll remove the strikeout in a week or two. Just making a point.
Like normal, Gail, you made your point very succinctly. Like many of your posts, you made me think. Well, what I read with this one is just plain sad. Any time a high-level certification is retired or killed, it just dumbs things down. I would post a reply on the MS Connect site, but I honestly don't think it would do any good.
Ed, I don't think any comment will say anything new, so I'd agree. But, enough up-votes on it might (not holding my breath, but it might), so please consider doing that at least.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 4, 2013 at 7:51 am
Just got back from WorldCon (SF Convention). Flew United for the trip back and the plane on Monday was cancelled because it had a flat tire and they couldn't find one in San Antonio... Maybe since everything is bigger in TX, they couldn't find the right size?
And can anyone explain to me why I spent a good part of my vacation in business meetings? For the convention, but still.
--------------------------------------
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
Viewing 15 posts - 41,161 through 41,175 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply