Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 14,446 through 14,460 (of 66,712 total)

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

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

Jason it's late go home. If I remember correctly it is Las Vegas where you work?

If so, stop at a few places along the strip, have a glass of refreshment ... you will get over this strange desire to document the istory for @#$% procedures.

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]

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

All right... I believe I've found all the places where I posted that code and have deleted it with an explanation. Needless to say, I'm a bit embarrassed. Ah... almost forgot... gotta see if I can find it on ASK...

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

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

What do you know. I'm surprised it was there back then. Wonder if it was in 60

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

I almost shudder to post this, but you all might like this:

http://lmgtfy.com/

as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index

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

Steve Jones - Editor (4/16/2010)
What do you know. I'm surprised it was there back then. Wonder if it was in 60

Did 6.0 come out before or after the date in the procedure?

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Steve Jones - Editor (4/16/2010)
What do you know. I'm surprised it was there back then. Wonder if it was in 60

I don't think so. I think 6.0 is too old - by virtue of the date in the proc.

Honestly, I was surprised too. I learned something today (albeit of little use).

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Jack Corbett (4/16/2010)
Steve Jones - Editor (4/16/2010)
What do you know. I'm surprised it was there back then. Wonder if it was in 60
Did 6.0 come out before or after the date in the procedure?

6.0 came out before that date. Not much before, but it was 95.

6.5 was released in 96 which would work well with that date in the proc.

And I'm not going to try to install 6 in order to try and find that proc. There has to be good reason they went from 6 to 6.5 in <= 1 yr.

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

WayneS SSC Guru Points: 95460 More actions · Answer 8

Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:
http://lmgtfy.com/
as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index

Steve, surely you've seen me use that before? Heck, I picked it up from here at least 6 mos ago!

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 9

WayneS (4/17/2010)
Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:
http://lmgtfy.com/
as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index
Steve, surely you've seen me use that before? Heck, I picked it up from here at least 6 mos ago!

Oh, but you can't repeat a good thing too often.

"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

WayneS SSC Guru Points: 95460 More actions · Answer 10

Grant Fritchey (4/17/2010)
WayneS (4/17/2010)
Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:
http://lmgtfy.com/
as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index
Steve, surely you've seen me use that before? Heck, I picked it up from here at least 6 mos ago!
Oh, but you can't repeat a good thing too often.

Oh I agree. And with some of these posters... it's just the best link to give them. Gives them their answer, and let's them know just how lazy they are.

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 11

WayneS (4/17/2010)
Grant Fritchey (4/17/2010)
WayneS (4/17/2010)
Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:
http://lmgtfy.com/
as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index
Steve, surely you've seen me use that before? Heck, I picked it up from here at least 6 mos ago!
Oh, but you can't repeat a good thing too often.
Oh I agree. And with some of these posters... it's just the best link to give them. Gives them their answer, and let's them know just how lazy they are.

I'm sure there are a percentage that notice and either feel a bit of shame or some indignation, but I'll bet the majority just cruise right by and don't even notice, as long as they get the answer they want.

"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

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

Yeah, those dates from Jason sound right. We upgraded from 4.2 to 6.0 to start a dev project, and then about 6 months in 6.5 came out. I don't remember why, but I think it was that 6.0 was missing stuff. Either things weren't finished, or my guess, they didn't work right. That was MS's first cut at this as the 4.2 was a sybase port.

It's not worth it, but if I remember, 60 was in the spring/summer of 95 and 65 was late 95/early 96 that it went RTM.

TomThomson SSC Guru Points: 104773 More actions · Answer 13

CirquedeSQLeil (4/16/2010)
That proc is a real piece of work - compare it some day to sql 2008.

There is very little difference - cosmetic bits (changes of captitalisation, "Exec" instead of "execute", deletion of a code fragment that was commented out in SQLS 2000, adding a rather useless comment), things required by system changes between 2000 and 2008 (using system view instead system table, using sysprocesses_ex instead of sysprocesses) and an interface change (adding the request_id column to the result set, which is pretty trivial in code terms). Why do you think it interesting to compare the two versions? (Or is my old version of sp_who2 different from the "real" 2008 version?)

Tom

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

Wayne,

Hadn't seen that before, but it's great. I bookmarked it to use it for some question.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 15

Steve Jones - Editor (4/17/2010)
Yeah, those dates from Jason sound right. We upgraded from 4.2 to 6.0 to start a dev project, and then about 6 months in 6.5 came out. I don't remember why, but I think it was that 6.0 was missing stuff. Either things weren't finished, or my guess, they didn't work right. That was MS's first cut at this as the 4.2 was a sybase port.
It's not worth it, but if I remember, 60 was in the spring/summer of 95 and 65 was late 95/early 96 that it went RTM.

I don't remember 60 at all, but I do remember having to reinstall & reconfigure when 6.5 came out and it was realy fast after we had the 6.0 install done.

"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