Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 8,686 through 8,700 (of 66,712 total)

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

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 1

Steve Jones - Editor (10/18/2009)
Or maybe they've changed the rules now that Jeff isn't serving :-D:-P:w00t:

SOM!!!:hehe:

---------------------------------------------------------
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."

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 2

Steve Jones - Editor (10/19/2009)
Bob Hovious 24601 (10/18/2009)
Where'd you get the hat? I have to make do with a colander reinforced with tin foil.
I think we'd like pictures from both you and Jeff. If you're worried about the EM waves, take an old fashioned Polariod, mail it to me and I'll scan it in 🙂

Heh... nah... that shirt you're wearing in your avatar outdoes us both. 😛

--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)

WayneS SSC Guru Points: 95460 More actions · Answer 3

Hey Jeff... can you FedEx me your biggest, baddest pork chop launcher? I think I'm in dire need of it.....

Just had a "developer" send me some code.

SP "a" has a cursor, that fires off 5 different SPs.

Each of those SPs then takes RBAR to a higher (errr, lower) life-form... it takes each column, one by one, and runs a select @oldvalue = column from table. Then it runs an update set column = @newvalue. Repeat for 28 columns.

... banging head on desk ...

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

WayneS (10/19/2009)
... banging head on desk ...

The developer's head right! 😉

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 5

Jack Corbett (10/19/2009)
WayneS (10/19/2009)
... banging head on desk ...
The developer's head right! 😉

That would certainly be better for stress-relief, and probably for productivity too. 😛

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 6

WayneS (10/19/2009)
Hey Jeff... can you FedEx me your biggest, baddest pork chop launcher? I think I'm in dire need of it.....
Just had a "developer" send me some code.
SP "a" has a cursor, that fires off 5 different SPs.
Each of those SPs then takes RBAR to a higher (errr, lower) life-form... it takes each column, one by one, and runs a select @oldvalue = column from table. Then it runs an update set column = @newvalue. Repeat for 28 columns.
... banging head on desk ...

Hmmmmm.... It doesn't happen to be for an audit trigger, does it? Does it also have an "event log" in the code you received? And, it's really long code?

--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)

WayneS SSC Guru Points: 95460 More actions · Answer 7

Jack Corbett (10/19/2009)
WayneS (10/19/2009)
... banging head on desk ...
The developer's head right! 😉

Oh how I wish he were local... then it would be his head 😀

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95460 More actions · Answer 8

Jeff Moden (10/19/2009)
WayneS (10/19/2009)
Hey Jeff... can you FedEx me your biggest, baddest pork chop launcher? I think I'm in dire need of it.....
Just had a "developer" send me some code.
SP "a" has a cursor, that fires off 5 different SPs.
Each of those SPs then takes RBAR to a higher (errr, lower) life-form... it takes each column, one by one, and runs a select @oldvalue = column from table. Then it runs an update set column = @newvalue. Repeat for 28 columns.
... banging head on desk ...
Hmmmmm.... It doesn't happen to be for an audit trigger, does it? Does it also have an "event log" in the code you received? And, it's really long code?

Nope, not an audit trigger. No event log (but if any columns are empty, they get posted to an error table). With 28 consecutive select/updates makes it too long.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Ron McCullough SSC Guru Points: 63877 More actions · Answer 9

WayneS
Just had a "developer" send me some code.

Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the individual is qualified and doing good work.

Bang their head(s) on the desk or you will continue to receive more like that.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 10

bitbucket-25253 (10/20/2009)
WayneS
Just had a "developer" send me some code.
Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the individual is qualified and doing good work.
Bang their head(s) on the desk or you will continue to receive more like that.

Can't argue with that.

The bad thing is that this is for a project that was outsourced... this is what the contractors are sending me!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

GSquared SSC Guru Points: 260824 More actions · Answer 11

WayneS (10/20/2009)
bitbucket-25253 (10/20/2009)
WayneS
Just had a "developer" send me some code.
Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the individual is qualified and doing good work.
Bang their head(s) on the desk or you will continue to receive more like that.
Can't argue with that.
The bad thing is that this is for a project that was outsourced... this is what the contractors are sending me!

I'm confused. I thought that was what outsourcing was for: To make you want to bang someone's head on a desk or wall or whatever.

- 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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 12

WayneS (10/20/2009)
bitbucket-25253 (10/20/2009)
WayneS
Just had a "developer" send me some code.
Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the individual is qualified and doing good work.
Bang their head(s) on the desk or you will continue to receive more like that.
Can't argue with that.
The bad thing is that this is for a project that was outsourced... this is what the contractors are sending me!

I hope it was not outsourced to Satyam... 🙂

-Roy

Ron McCullough SSC Guru Points: 63877 More actions · Answer 13

WayneS

You are between a rock and a hard place. My sympathies are with you.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 14

Has everyone here started using ask.sqlservercentral.com ? I still cannot login since our works firewall will not allow yahoo authentication that is used for OpenID

Too bad the site does not have a local registration like here.

-Roy

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 15

Steve Jones - SSC Editor

SSC Guru

Points: 736270

October 20, 2009 at 12:54 pm

#1068450

Good luck, Wayne. Remember, it's just a job.