Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 61,276 through 61,290 (of 66,712 total)

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

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

Sean Lange - Thursday, March 29, 2018 1:13 PM
Jeff Moden - Thursday, March 29, 2018 1:01 PM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Now that you mention it, no. I hope he's OK.
He still posts over at SO pretty frequently. To be honest I spend a lot more time over there lately. Even though the attitude is pretty crappy, at least the software works.

Yowch! Hey, Steve Jones... tell the folks at RedGate. We're losing the good guys because of the crappy forum code! Time for them to make an "investment".

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

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

Lynn Pettis - Thursday, March 29, 2018 1:09 PM
Jeff Moden - Thursday, March 29, 2018 1:01 PM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Now that you mention it, no. I hope he's OK.
I went to a "Killing Cursors" session at SQL Saturday 700. It wasn't really about killing cursors. I was thinking about perhaps doing a presentation about eliminating cursors and he did start a series of articles back in 2009.

Just curious... what did the session end up being about if not about "Killing Cursors"???

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

Ed Wagner - Thursday, March 29, 2018 12:49 PM
Nice to have you on board. Good twist. 0x6E75716E65482E205161706C61

I didn't get this :unsure:

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

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

Jeff Moden - Thursday, March 29, 2018 1:37 PM
Lynn Pettis - Thursday, March 29, 2018 1:09 PM
Jeff Moden - Thursday, March 29, 2018 1:01 PM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Now that you mention it, no. I hope he's OK.
I went to a "Killing Cursors" session at SQL Saturday 700. It wasn't really about killing cursors. I was thinking about perhaps doing a presentation about eliminating cursors and he did start a series of articles back in 2009.
Just curious... what did the session end up being about if not about "Killing Cursors"???

More about reading execution plans, dynamic SQL, CTE's (regular and recursive). I wrote a procedure that eliminated the speakers while loops and she said it really did meet the requirements of her presentation which, by the way, looks like it may be getting a rename.

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

Lynn Pettis - Thursday, March 29, 2018 1:44 PM
Jeff Moden - Thursday, March 29, 2018 1:37 PM
Lynn Pettis - Thursday, March 29, 2018 1:09 PM
Jeff Moden - Thursday, March 29, 2018 1:01 PM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Now that you mention it, no. I hope he's OK.
I went to a "Killing Cursors" session at SQL Saturday 700. It wasn't really about killing cursors. I was thinking about perhaps doing a presentation about eliminating cursors and he did start a series of articles back in 2009.
Just curious... what did the session end up being about if not about "Killing Cursors"???
More about reading execution plans, dynamic SQL, CTE's (regular and recursive). I wrote a procedure that eliminated the speakers while loops and she said it really did meet the requirements of her presentation which, by the way, looks like it may be getting a rename.

Wow, now she just jumped down my throat because I refactored her code and sent it back to her. If she hadn't freely offered her sandbox to everyone in her presentation, I wouldn't have been able to do it.

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

Jeff Moden - Thursday, March 29, 2018 1:35 PM
Sean Lange - Thursday, March 29, 2018 1:13 PM
Jeff Moden - Thursday, March 29, 2018 1:01 PM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Now that you mention it, no. I hope he's OK.
He still posts over at SO pretty frequently. To be honest I spend a lot more time over there lately. Even though the attitude is pretty crappy, at least the software works.
Yowch! Hey, Steve Jones... tell the folks at RedGate. We're losing the good guys because of the crappy forum code! Time for them to make an "investment".

Certainly didn't mean it as a slam but it is true. The forum code is just horrific for posting code and links. I often just give up when posting answers because it is so frustrating.

_______________________________________________________________

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/

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 7

Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?

Yeah he's good, spends all day bitchin' about The Orange One on FB 🙂

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

David Burrows SSC Guru Points: 65142 More actions · Answer 8

Ed Wagner - Thursday, March 29, 2018 12:49 PM
Lynn Pettis - Thursday, March 29, 2018 11:48 AM
Ed Wagner - Thursday, March 29, 2018 11:40 AM
Eirikur Eiriksson - Wednesday, March 28, 2018 9:26 AM
jasona.work - Wednesday, March 28, 2018 9:16 AM
Eirikur Eiriksson - Wednesday, March 28, 2018 8:59 AM
jasona.work - Wednesday, March 28, 2018 8:52 AM
Steve Jones - SSC Editor - Wednesday, March 28, 2018 8:34 AM
jasona.work - Wednesday, March 28, 2018 6:07 AM
Boy, it's going to be a lonely, quiet day today...
Of the other 5 members of the team I'm on:
4 are work-from-home today
1 is on vacation
Who needs human contact?
It's weird. Last week my wife was in Boston with my daughter. Other kid worked late and didn't come home a couple nights. Just me trying to work in silence and dogs staring at me. Very odd. I'm usually alone, but my wife pops in and out and kid usually home around 2-3.
On my telework days, I *have* to eventually turn on a radio or something, and ideally to a news or talk station or I start getting real antsy and can't focus on work.
At least, while I'm the only team member in the office, there's other people in the office from other teams, so there actually is *some* human contact, just not people I normally interact with much.
My favorite would be:
0x536F20676F6F6420746F2066696E616C6C79206D65657420796F7520696E20706572736F6E21
😎
0x42757420427261696E2C2077686572652061726520776520676F696E6720746F2066696E6420612036272D3322206368696D70616E7A6565207468617420737065616B7320506F6C69736820616E64206C6F6F6B73206C696B6520526F646E65792044616E6765726669656C643F
0x496E2057657374204C6F6E646F6E2C2070726163746963616C6C79206F6E20657665727920636F726E6572
😎
0x49206C696B6520526F646E65792044616E6765726669656C642E204772656174206163746F72202D2065787472612073746F757421
0x560061002000620065006E0065002C00200070006F00730073006F00200061006E00630068006500200075006E00690072006D006900200061006C00200064006900760065007200740069006D0065006E0074006F002E00
Nice to have you on board. Good twist. 0x6E75716E65482E205161706C61

0x5468697320697320736572696F75736C792067657474696E67206F7574206F662068616E642E
😛

Far away is close at hand in the images of elsewhere.
Anon.

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

ChrisM@Work - Tuesday, April 3, 2018 3:13 AM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Yeah he's good, spends all day bitchin' about The Orange One on FB 🙂

Glad I don't follow him on FB. If she who won't shutup had won I would have been complaining all day long about an unindicted, unconvicted,felon serving in the WH.

jasona.work SSC Guru Points: 50117 More actions · Answer 10

Lynn Pettis - Tuesday, April 3, 2018 7:09 AM
ChrisM@Work - Tuesday, April 3, 2018 3:13 AM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Yeah he's good, spends all day bitchin' about The Orange One on FB 🙂
Glad I don't follow him on FB. If she who won't shutup had won I would have been complaining all day long about an unindicted, unconvicted,felon serving in the WH.

GENTLEMEN!!!
No politics around the water cooler!

Sheesh, I come here to try to get AWAY from politics...
😀
(Although, if someone started up a "Politics and policies - MUST HAVE THICK SKIN" topic, I'd probably be all over it...)

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

jasona.work - Tuesday, April 3, 2018 8:13 AM
Lynn Pettis - Tuesday, April 3, 2018 7:09 AM
ChrisM@Work - Tuesday, April 3, 2018 3:13 AM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Yeah he's good, spends all day bitchin' about The Orange One on FB 🙂
Glad I don't follow him on FB. If she who won't shutup had won I would have been complaining all day long about an unindicted, unconvicted,felon serving in the WH.
GENTLEMEN!!!
No politics around the water cooler!
Sheesh, I come here to try to get AWAY from politics...
😀
(Although, if someone started up a "Politics and policies - MUST HAVE THICK SKIN" topic, I'd probably be all over it...)

Have you ever been around a real water cooler? Politics is the least of your worries. I'll try to refrain in the future.

jasona.work SSC Guru Points: 50117 More actions · Answer 12

Lynn Pettis - Tuesday, April 3, 2018 8:24 AM
jasona.work - Tuesday, April 3, 2018 8:13 AM
Lynn Pettis - Tuesday, April 3, 2018 7:09 AM
ChrisM@Work - Tuesday, April 3, 2018 3:13 AM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Yeah he's good, spends all day bitchin' about The Orange One on FB 🙂
Glad I don't follow him on FB. If she who won't shutup had won I would have been complaining all day long about an unindicted, unconvicted,felon serving in the WH.
GENTLEMEN!!!
No politics around the water cooler!
Sheesh, I come here to try to get AWAY from politics...
😀
(Although, if someone started up a "Politics and policies - MUST HAVE THICK SKIN" topic, I'd probably be all over it...)
Have you ever been around a real water cooler? Politics is the least of your worries. I'll try to refrain in the future.

Sorry, I kind of meant that to be more a semi-humorous / semi-sarcastic comment. Please, do not refrain on my account.
(For the record, I wasn't a fan of *either* of the two big-party candidates)

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

jasona.work - Tuesday, April 3, 2018 8:30 AM
Lynn Pettis - Tuesday, April 3, 2018 8:24 AM
jasona.work - Tuesday, April 3, 2018 8:13 AM
Lynn Pettis - Tuesday, April 3, 2018 7:09 AM
ChrisM@Work - Tuesday, April 3, 2018 3:13 AM
Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Yeah he's good, spends all day bitchin' about The Orange One on FB 🙂
Glad I don't follow him on FB. If she who won't shutup had won I would have been complaining all day long about an unindicted, unconvicted,felon serving in the WH.
GENTLEMEN!!!
No politics around the water cooler!
Sheesh, I come here to try to get AWAY from politics...
😀
(Although, if someone started up a "Politics and policies - MUST HAVE THICK SKIN" topic, I'd probably be all over it...)
Have you ever been around a real water cooler? Politics is the least of your worries. I'll try to refrain in the future.
Sorry, I kind of meant that to be more a semi-humorous / semi-sarcastic comment. Please, do not refrain on my account.
(For the record, I wasn't a fan of *either* of the two big-party candidates)

To be honest, Trump wasn't my first choice either, but (and I will leave it there).

Luis Cazares SSC Guru Points: 183706 More actions · Answer 14

Any help or opinions on this?
https://www.sqlservercentral.com/Forums/1930195/Removing-stored-procedures-to-move-to-cloud

Thank you.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 15

Added my two cents. (Due to inflation, they are worth at least $0.020005 by now)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/