Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 49,621 through 49,635 (of 66,738 total)

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

GilaMonster (7/23/2015)
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Fantastic Gail! Congratulations.

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

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 2

GilaMonster (7/23/2015)
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

WHOOO HOOO! You go! And with distinction even? Even better.

Congrats.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 3

Sigh. I feel like I'm pulling teeth on this forum some days.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Brandie Tarvin (7/23/2015)
Sigh. I feel like I'm pulling teeth on this forum some days.

Are you now toothless then?

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

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

Brandie Tarvin (7/23/2015)
Sigh. I feel like I'm pulling teeth on this forum some days.

Thinking you should have been a Dentist?

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 6

SQLRNNR (7/23/2015)
Brandie Tarvin (7/23/2015)
Sigh. I feel like I'm pulling teeth on this forum some days.
Are you now toothless then?

No, but I'd love to be a Night Fury. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 7

Lynn Pettis (7/23/2015)
Brandie Tarvin (7/23/2015)
Sigh. I feel like I'm pulling teeth on this forum some days.
Thinking you should have been a Dentist?

I'd certainly get paid more. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Brandie Tarvin (7/23/2015)
SQLRNNR (7/23/2015)
Brandie Tarvin (7/23/2015)
Sigh. I feel like I'm pulling teeth on this forum some days.
Are you now toothless then?
No, but I'd love to be a Night Fury. @=)

Ha - you go Hiccup!

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

GilaMonster (7/23/2015)
I don't know how things are done in the US, but here 75% is the threshold for a degree to be awarded "With Distinction"

Congratulations, Gail. Well done!

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

SQLRNNR (7/23/2015)
Eirikur Eiriksson (7/23/2015)
Just a thought,but don't you love your job when:
a) you observe your systems for a while, then make one small change that improves performance significantly and massively reduces the load on the servers.
2) you reduce the outages/faults by 100%
3) you tune the most expensive queries and the execution time drops from 10+ hours to less than 10 seconds.
as I said, just a thought:-), please share if you have similar experience!
😎
yes
yes
and yes

Yes, yes and absolutely yes. My most rewarding one was one that took over 30 hours and I got it down to about 20 minutes. The most impactful one was shaving about 4 seconds off a 4.6 second run. Of course, given that it ran thousands of times per day, the impact was huge.

I find that the job satisfaction when you sit back and admire your work is huge there. Then, after that 5 minutes, on to what's next. 😉

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Sean Lange SSC Guru Points: 286590 More actions · Answer 11

I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

MVXJDTA.MPDOPE.POOPNO

Seriously that table has the "dope poop"!!!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

Sean Lange (7/23/2015)
I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.
MVXJDTA.MPDOPE.POOPNO
Seriously that table has the "dope poop"!!!!

I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Sean Lange (7/23/2015)
I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.
MVXJDTA.MPDOPE.POOPNO
Seriously that table has the "dope poop"!!!!

lmao

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

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

Ed Wagner (7/23/2015)
Sean Lange (7/23/2015)
I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.
MVXJDTA.MPDOPE.POOPNO
Seriously that table has the "dope poop"!!!!
I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).

Let me guess:

ORNO - Order Number

PONO - Purchase Order Number

PORN - Purchase Order Return Number

Ed Wagner SSC Guru Points: 287026 More actions · Answer 15

Lynn Pettis (7/23/2015)
Ed Wagner (7/23/2015)
Sean Lange (7/23/2015)
I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.
MVXJDTA.MPDOPE.POOPNO
Seriously that table has the "dope poop"!!!!
I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).
Let me guess:
ORNO - Order Number
PONO - Purchase Order Number
PORN - Purchase Order Return Number

Have you worked with Baan :sick: before or are you just that accustomed to ERP system column names?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions