Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 36,211 through 36,225 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

TomThomson SSC Guru Points: 104773 More actions · Answer 1

Gianluca Sartori (5/22/2012)
2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you buy the training at all?

I think I can answer that one for you. The "smartass" may not have bought the training, he may have had it thrust upon him by an employer, with no option but to attend. And he may actually know better than the instructor. I've been on both sides of that - not so expert instructor with expert pupil, and expert pupil with not-so-expert instructor.

Tom

Revenant SSC-Forever Points: 42467 More actions · Answer 2

Gianluca Sartori (5/22/2012)
. . . Has any of you worked as a trainer? Thoughts?

Yes, I did -years ago, for IBM.

I mention it because they expected, and paid, 5 days of preparation for each day taught.

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

L' Eomot Inversé (5/22/2012)
Gianluca Sartori (5/22/2012)
2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you buy the training at all?
I think I can answer that one for you. The "smartass" may not have bought the training, he may have had it thrust upon him by an employer, with no option but to attend. And he may actually know better than the instructor. I've been on both sides of that - not so expert instructor with expert pupil, and expert pupil with not-so-expert instructor.

Quite true. Since I'm the instructor, that does not yeald impossible.

This week's one advocates cursors are always better than set-based.

He bought the training and chose the topics for himself and his colleagues.

He keeps interrupting me in the few moments he doesn't sleep or stare at me with a skeptical look in his eyes.

In my wildest dreams I decapitate him with a big medieval sword screaming "there can be only one".

-- Gianluca Sartori

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

Revenant (5/22/2012)
Gianluca Sartori (5/22/2012)
. . . Has any of you worked as a trainer? Thoughts?
Yes, I did -years ago, for IBM.
I mention it because they expected, and paid, 5 days of preparation for each day taught.

Impressive. I'm not paid for preparation.

-- Gianluca Sartori

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Gianluca Sartori (5/22/2012)
L' Eomot Inversé (5/22/2012)
Gianluca Sartori (5/22/2012)
2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you buy the training at all?
I think I can answer that one for you. The "smartass" may not have bought the training, he may have had it thrust upon him by an employer, with no option but to attend. And he may actually know better than the instructor. I've been on both sides of that - not so expert instructor with expert pupil, and expert pupil with not-so-expert instructor.
Quite true. Since I'm the instructor, that does not yeald impossible.
This week's one advocates cursors are always better than set-based.
He bought the training and chose the topics for himself and his colleagues.
He keeps interrupting me in the few moments he doesn't sleep or stare at me with a skeptical look in his eyes.
In my wildest dreams I decapitate him with a big medieval sword screaming "there can be only one".

Challenge him: 1,000,000 row update for running and group totals. You use the quirky update and he uses a cursor. You win, he has to be quiet the rest of the week. Heck, Jeff already has everything setup in his article, all you have to do is cut and paste.

:w00t:

spaghettidba SSC Guru Points: 105732 More actions · Answer 6

Lynn Pettis (5/22/2012)
Gianluca Sartori (5/22/2012)
L' Eomot Inversé (5/22/2012)
Gianluca Sartori (5/22/2012)
2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you buy the training at all?
I think I can answer that one for you. The "smartass" may not have bought the training, he may have had it thrust upon him by an employer, with no option but to attend. And he may actually know better than the instructor. I've been on both sides of that - not so expert instructor with expert pupil, and expert pupil with not-so-expert instructor.
Quite true. Since I'm the instructor, that does not yeald impossible.
This week's one advocates cursors are always better than set-based.
He bought the training and chose the topics for himself and his colleagues.
He keeps interrupting me in the few moments he doesn't sleep or stare at me with a skeptical look in his eyes.
In my wildest dreams I decapitate him with a big medieval sword screaming "there can be only one".
Challenge him: 1,000,000 row update for running and group totals. You use the quirky update and he uses a cursor. You win, he has to be quiet the rest of the week. Heck, Jeff already has everything setup in his article, all you have to do is cut and paste.
:w00t:

I especially like the "cut" part 😀

-- Gianluca Sartori

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 7

Gianluca Sartori (5/22/2012)
Has any of you worked as a trainer? Thoughts?

Yes... Certified and decorated U.S.Navy electronics and computer instructor (certified to teach all 1,040 hours of the BEE course and wrote a 200 hour course for digital electronics/microprocessors) . Wrote and taught about a dozen 16 hour PC related courses for Raytheon.

In my experience and depending on the subject and previous familiarity to teach a course well, it takes 10 minutes to 8 hours of prep time for each hour "on the stump". To develop a new course, it takes 10 minutes to 24 hours for each hour "on the stump". Sometimes, even a little longer depending on the subject and what the training aids are going to be.

I have some 1 hour presentations that have more than 100 hours in them with about 20% of that being pure research, 60 or 70% being the writing and testing of the code, and the rest actually building the presentation.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 8

Gianluca Sartori (5/22/2012)
Lynn Pettis (5/22/2012)
Gianluca Sartori (5/22/2012)
L' Eomot Inversé (5/22/2012)
Gianluca Sartori (5/22/2012)
2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you buy the training at all?
I think I can answer that one for you. The "smartass" may not have bought the training, he may have had it thrust upon him by an employer, with no option but to attend. And he may actually know better than the instructor. I've been on both sides of that - not so expert instructor with expert pupil, and expert pupil with not-so-expert instructor.
Quite true. Since I'm the instructor, that does not yeald impossible.
This week's one advocates cursors are always better than set-based.
He bought the training and chose the topics for himself and his colleagues.
He keeps interrupting me in the few moments he doesn't sleep or stare at me with a skeptical look in his eyes.
In my wildest dreams I decapitate him with a big medieval sword screaming "there can be only one".
Challenge him: 1,000,000 row update for running and group totals. You use the quirky update and he uses a cursor. You win, he has to be quiet the rest of the week. Heck, Jeff already has everything setup in his article, all you have to do is cut and paste.
:w00t:
I especially like the "cut" part 😀

I'll be honest, however, I don't think that would even make him quiet, but it might just demonstrate to the rest of the class that cursors are not necessarily the best option.

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 9

Lynn Pettis (5/22/2012)
I'll be honest, however, I don't think that would even make him quiet...

I agree... it's not his mouth that's doing the talking. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

spaghettidba SSC Guru Points: 105732 More actions · Answer 10

Thanks everyone for the suggestions and opinions.

If everything goes well, I won't be working as a trainer any more.

I'm negotiating a contract as DBA/DBD. It's going to be a life change, but looks very promising.

Fingers crossed.

-- Gianluca Sartori

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Gianluca Sartori (5/22/2012)
Thanks everyone for the suggestions and opinions.
If everything goes well, I won't be working as a trainer any more.
I'm negotiating a contract as DBA/DBD. It's going to be a life change, but looks very promising.
Fingers crossed.

Best of luck!

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Gianluca Sartori (5/22/2012)
L' Eomot Inversé (5/22/2012)
Gianluca Sartori (5/22/2012)
2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you buy the training at all?
I think I can answer that one for you. The "smartass" may not have bought the training, he may have had it thrust upon him by an employer, with no option but to attend. And he may actually know better than the instructor. I've been on both sides of that - not so expert instructor with expert pupil, and expert pupil with not-so-expert instructor.
Quite true. Since I'm the instructor, that does not yeald impossible.
This week's one advocates cursors are always better than set-based.
He bought the training and chose the topics for himself and his colleagues.
He keeps interrupting me in the few moments he doesn't sleep or stare at me with a skeptical look in his eyes.
In my wildest dreams I decapitate him with a big medieval sword screaming "there can be only one".

If you have one of those, you also have my deepest sympathy.

I feel cheesewire strained tight around the appropriate parts (which are somewhat lower than the neck) might be more satisfying than a sword, and just as effective from a Darwinian point of view. Mais chacun peut légitimement avoir son propre goût.

Tom

Revenant SSC-Forever Points: 42467 More actions · Answer 13

Gianluca Sartori (5/22/2012)
Thanks everyone for the suggestions and opinions.
If everything goes well, I won't be working as a trainer any more.
I'm negotiating a contract as DBA/DBD. It's going to be a life change, but looks very promising.
Fingers crossed.

I will keep my fiungers crossed for you, too.

Does that 'DBA' stand for Administrator or Architect?

Dwain Camps SSC Guru Points: 86948 More actions · Answer 14

Jeff Moden (5/22/2012)
In my experience and depending on the subject and previous familiarity to teach a course well, it takes 10 minutes to 8 hours of prep time for each hour "on the stump". To develop a new course, it takes 10 minutes to 24 hours for each hour "on the stump". Sometimes, even a little longer depending on the subject and what the training aids are going to be.
I have some 1 hour presentations that have more than 100 hours in them with about 20% of that being pure research, 60 or 70% being the writing and testing of the code, and the rest actually building the presentation.

My company develops bespoke applications for clients. Try charging them for that kind of time for a training session on their brand-spanking new application. No way! But I agree 100%.

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Stefan Krzywicki (5/22/2012)
Lynn Pettis (5/22/2012)
If people would just format their code they could figure out some of their own problems. Geez.
Many should format it all at once, like with Format C:\

+100

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