February 29, 2012 at 6:15 am
Brandie Tarvin (2/29/2012)
Koen Verbeeck (2/28/2012)
Some try to add my to their LinkedIn network with "Person X has indicated that you are a Friend". Euh.... no.That one is annoying me.
Likewise. If someone claims I'm a friend then I should at least recognise their name. I just decline most of those.
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
February 29, 2012 at 6:34 am
Koen Verbeeck (2/29/2012)
Gianluca Sartori (2/29/2012)
Revenant (2/28/2012)
Gianluca Sartori (2/28/2012)
Lynn Pettis (2/28/2012)
I guess we need to start encouraging more people to consider DBA work as a career choice.I'm genetically unable to manage people. When I disagree with somebody (on a technical matter I am quite sure of) I try to explain my point of view at most twice. If you insist doing things your way, go ahead and bang your head to the wall.
This doesn't make a good boss...
Maybe it's no so good for the company if people bang their heads to the wall (all those holes), but as a learning experience for that person it's quite OK. They probably have to bang their heads only a couple of times before they realize you know what you're talking about.
You find out rather quickly if they have the capacity to learn and adapt.
Or if Brick Walls are in order. 😀
February 29, 2012 at 6:43 am
You know, I get that menus have limited space, but seriously, doesn't anyone know basic grammar rules?
delicate jumbo lump lightly breaded with housemade tartar sauce and sweet-hot sambal
This crab cake description told me that the tartar sauce and sambal made up the breading for the lump.
<headdesk>
Why? Tell me, why????
February 29, 2012 at 9:08 am
Koen Verbeeck (2/29/2012)
Triple heart attack this morning when I stumbled accross this:It's even marked as answer. :crying:
What's even more unsettling, is that that a link to this thread was provided by a Microsoft moderator in another thread...:blink:
:sick:
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
February 29, 2012 at 9:14 am
Brandie Tarvin (2/29/2012)
You know, I get that menus have limited space, but seriously, doesn't anyone know basic grammar rules?delicate jumbo lump lightly breaded with housemade tartar sauce and sweet-hot sambal
This crab cake description told me that the tartar sauce and sambal made up the breading for the lump.
<headdesk>
Why? Tell me, why????
I'm trying to recall where the one is that always gets me... It's under the Sandwiches section of the menu, so it's user error too, but it just says Chicken Salad and somehow I have ordered it multiple times expecting a salad with chicken, trying to be healthy. Instead I get mayo-laden goop on a buttery croissant. (and laughed at by my wife)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 29, 2012 at 9:31 am
GilaMonster (2/29/2012)
Lynn Pettis (2/28/2012)
I didn't pile on, I just tried to explain what that one particular question he was asking regarding updatation and insertion.Which, btw, I could interpret just fine, was trying to convey to OP that the question was badly phrased to the point of not being understandable.
Actually Gail, I wasn't concerned whether you understood, I was thinking of others that might come along reading the thread. They may not understand the question itself or your response.
February 29, 2012 at 9:48 am
SQLRNNR (2/29/2012)
Koen Verbeeck (2/29/2012)
Triple heart attack this morning when I stumbled accross this:It's even marked as answer. :crying:
What's even more unsettling, is that that a link to this thread was provided by a Microsoft moderator in another thread...:blink:
:sick:
It makes me sick too.
To me, the situation seems one where it might be (but probably isn't, even if the isolation level is serializable) useful to use a shared table lock (to avoid taking lots of row locks, upgrading them to page locks, and maybe ending up upgrading the page locks to table level) - nolock will do no harm if there's an absolute guarantee that nothing can be updating the table or inserting into it while the reading is happening, neither now nor ever in the future despite any strange contingencies that may arise, but not if the cast iron perpetual guarantee doesn't exist. But of course the only safe and sure way to get such a guarantee is to use tablock instead of nolock.
Tom
February 29, 2012 at 10:39 am
L' Eomot Inversé (2/29/2012)
nolock will do no harm if there's an absolute guarantee that nothing can be updating the table or inserting into it while the reading is happening, neither now nor ever in the future despite any strange contingencies that may arise
But if it is guaranteed that there won't be concurrent changes, there's little to no point in using nolock anyway.
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
February 29, 2012 at 10:44 am
Something different.
Stephen Uden (MS Skills and Economic Affairs panjandrum) sounded off yesterday to some UK legislators about the way our universities are handling STEM subjects in general and CS in particular; as far as I can tell from the reports I've seen his main beef is that the universities are educating people about computer science instead of training them in the latest MS technologies - of course that may be a slant in the reports, I haven't seen a transcript of what he actually said - and that this has resulted in MS customers (who can afford, apparently, neither to pay recruits what MS would pay them if they went to MS instead nor to provide training in particular technologies) suffering a skills shortage.
The response to one of those reports from one John Styles is something that might well bring a smile of recognition to users of this water cooler:
I know I say this every time... but...
The alleged shortage is of what it has always been - 21 year olds with 5 years experience of 2 year old technologies who'll work 70 hour weeks for peanuts without making waves.
My own reaction was to be thankfull that Udell was talking to the Lords Science and Technology committee, not to a Commons committee; the Lords has a far higher proportion of members whose IQ exceeds their boot size than does the Commons, so they are less likely to do something stupid as a result of what someone tells them.
Tom
February 29, 2012 at 10:48 am
GilaMonster (2/29/2012)
L' Eomot Inversé (2/29/2012)
nolock will do no harm if there's an absolute guarantee that nothing can be updating the table or inserting into it while the reading is happening, neither now nor ever in the future despite any strange contingencies that may ariseBut if it is guaranteed that there won't be concurrent changes, there's little to no point in using nolock anyway.
Which is why I said that it makes more sense if such a guarantee does exist (which I am unlikely ever to believe) to use tablock than to use nolock.
Tom
February 29, 2012 at 2:25 pm
L' Eomot Inversé (2/29/2012)
I know I say this every time... but...
The alleged shortage is of what it has always been - 21 year olds with 5 years experience of 2 year old technologies who'll work 70 hour weeks for peanuts without making waves.
Absolutely perfect.
March 1, 2012 at 6:50 am
Revenant (2/29/2012)
L' Eomot Inversé (2/29/2012)
I know I say this every time... but...
The alleged shortage is of what it has always been - 21 year olds with 5 years experience of 2 year old technologies who'll work 70 hour weeks for peanuts without making waves.
Absolutely perfect.
+1
March 1, 2012 at 8:00 am
Revenant (2/29/2012)
L' Eomot Inversé (2/29/2012)
I know I say this every time... but...
The alleged shortage is of what it has always been - 21 year olds with 5 years experience of 2 year old technologies who'll work 70 hour weeks for peanuts without making waves.
Absolutely perfect.
And it isn't just in IT either.
http://www.cjr.org/the_audit/the_cant_find_workers_meme.php
Places just want workers to appear, magically trained and don't want to pay them what they're worth.
--------------------------------------
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
March 1, 2012 at 9:18 am
Stefan Krzywicki (3/1/2012)
Revenant (2/29/2012)
L' Eomot Inversé (2/29/2012)
I know I say this every time... but...
The alleged shortage is of what it has always been - 21 year olds with 5 years experience of 2 year old technologies who'll work 70 hour weeks for peanuts without making waves.
Absolutely perfect.
And it isn't just in IT either.
http://www.cjr.org/the_audit/the_cant_find_workers_meme.php
Places just want workers to appear, magically trained and don't want to pay them what they're worth.
There are legit points on both sides of that argument.
Loss of apprenticeship programs as a primary way to get future skilled workers is a very common "penny wise, dollar foolish" situation in most business sectors.
At the same time, how do you apprentice someone who "graduated high school" or even college, but who can't figure out what an equilateral triangle is, whether 1/10 of a foot is longer than or shorter than 2 X 7/8 of an inch, and can't read a basic instruction manual on operating a machine? (Those basic skills, geometry, addition of fractions, and technical reading, are in short supply in most of our college and high school grads these days.)
Even on this thread, we often bemoan posts by people who can't answer basic DBA interview questions, but do we complain about the fact that many interview questions would block a person from ever getting the experience in the first place, or do we suggest to people that they get a copy of Dev Edition and work things out on their own time, or possibly inflict their n00bness on a charity as a volunteer?
How many of those of us with senior-level technical skills, or even "journeyman" level technical skills, have expressed an interest to an employer, in training some "n00b" on the art of DBAing? Not, "would be willing if they forced me to", not "I'm already overloaded, how could I possibly make the time to train someone who may or may not even be interested after he finds out how much tedium and work it involves?", not "I help out on the forums". Not even, "I would if someone asked me to". I'm talking about making it clear to an employer that you consider it a good idea and would like to manage such an apprenticeship program. I think Jeff has. Who else?
It goes both ways.
(I'm trying to keep this light with things like "n00b" and so on. Don't take any of this too seriously. But it is a point to ponder.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 1, 2012 at 9:34 am
Good points, Gus, though I'm not sure I'd say most kids can't figure those things out. At least I hope that's not the case. Some days I wonder as well.
I do think that this is one of those areas in IT (can't speak for all areas), where we are woefully immature. We don't do a good job of bringing new people along as a group. We expect them to sink/swim on their own. And we too often berate people for not knowing something simple, when they might have a hole in that particular area, but know much about other things.
In fact, I am guilty of this, despite the constant reminders I get. On the MVP private email list, I see (what I consider) beginning questions from MVPs at times, often because they are tackling some new area of SQL Server they've never seen. Even when they're an expert in many other areas.
I think we forget that progression in SQL Server, or tech, isn't a linear progression. We don't learn a, then b, then c, then require those building blocks to learn d. We skip around, and that works (somewhat) much of the time.
I wish we did more apprenticeships. I think that a number of us could stand with spending a little more time on being well rounded and grounded. Of course, that would require us to (as a group) decide what basics we need and how we should learn them. I had hoped at some point PASS would do that, but they haven't even attempted to provide guidance and help for building knowledge.
Viewing 15 posts - 34,531 through 34,545 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply