Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 52,726 through 52,740 (of 66,712 total)

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

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

Ed Wagner (2/12/2016)
Lynn Pettis (2/12/2016)
Grumpy DBA (2/12/2016)
We will be transitioning to "mountain time". Wake up, breakfast, try to get first chair, snowboard/ski until hungry, grab a quick bite, snowboard/ski until the lifts close, some apres ski possibly mixed in with dinner, a few adult beverages, back to the condo for sleep and do it all over again. Pure mountain bliss.
Many years ago while still in the Air Force and stationed at Cheyenne Mountain Complex I did something like that. My parents had two time share condos in Vail and I was going to spend two weeks up there skiing. Sorry to say I only lasted a week. After seven days I was too sore and tired to go another week.
My days are going to involve getting up, checking the savanna for animals, going to a theme park, making it to my restaurant reservations, seeing cool things with my wife and daughter, enjoying fireworks at night and trying to get "it's a small world" out of my head. Oh yeah, and it's going to be much warmer than it is in Michigan. It'll be a nice break from the weather.

It won't work. I went to Disney World in the mid '70's and I still can't get that damned song out of my head! 😛

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

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

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?

I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...

On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!

For those who still have to work today, well, been there, done that...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?

Shocked that someone bothered to test.

Insulted would require the tone to be "I'm pretty sure this doesn't work, but I'll check just in case, by some miracle, it does."

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

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

jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...

I'd say "Thanks for the feedback". Here, each change to each piece of code is heavily peer reviewed and documented, at every stage of the route to production: not just an individual either - usually a couple of peers working through the code line by line with the dev.

^{“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

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...

I'd be happy as hell. I don't assume that I know everything, nor should anyone else. Trust but verify.

"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

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

GilaMonster (2/15/2016)
jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
Shocked that someone bothered to test.
Insulted would require the tone to be "I'm pretty sure this doesn't work, but I'll check just in case, by some miracle, it does."

/me looks down, swings foot back and forth

I was the one who tested, and commented that the solution was correct.

(Which after I thought about the question I expected it to work the way I thought it should)

((Over here: When using Domain Groups to manage users, how will they show in Audits / Traces / etc?))

Now I'm trying to figure out Reporting Services, building a report that I can (hopefully) set up on my new work servers to spit out the most recent backup results for both me and the bosses...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

jasona.work (2/15/2016)
/me looks down, swings foot back and forth

Huh?

My comment wasn't a slight. If someone told me they were testing I'd be surprised because most people don't bother and assume that provided code is correct.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

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

GilaMonster (2/15/2016)
jasona.work (2/15/2016)
/me looks down, swings foot back and forth
Huh?
My comment wasn't a slight. If someone told me they were testing I'd be surprised because most people don't bother and assume that provided code is correct.

I didn't take it that way, I was trying to be a bit "cute" in my reply to you...

I probably should've put something in there to indicate such...

*sigh* the downside to text-only interactions, it's hard to get the right mix to indicate your intent / attitude...

Smileys only get you so far...

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

jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...

I would be totally overjoyed.

I always tell people to verify and test anything that they take from the internet. I am not nearly vain enough to think that I should be the exception to that rule.

Really, I wish more people would get into the habit of taking the internet with a healthy dose of salt.

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/

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 10

Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...
I would be totally overjoyed.
I always tell people to verify and test anything that they take from the internet. I am not nearly vain enough to think that I should be the exception to that rule.
Really, I wish more people would get into the habit of taking the internet with a healthy dose of salt.

Come on. People don't put stuff up there if it's not true.

"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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 11

jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...

I actually don't care what kind of a chip they may carry on their shoulder, I'm glad they tested it. Now, if we can just get people to test it (whatever IT is) [font="Arial Black"]correctly[/font]. For example, almost everyone on the internet that I've seen run tests on CSV splitters has done it wrong from both from a functionality/accuracy standpoint and a performance standpoint and that includes some of the serious supposed heavy hitters.

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

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

Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...
I would be totally overjoyed.
I always tell people to verify and test anything that they take from the internet. I am not nearly vain enough to think that I should be the exception to that rule.
Really, I wish more people would get into the habit of taking the internet with a healthy dose of salt.
Come on. People don't put stuff up there if it's not true.

Now wait just a minute here...are you telling me that everything on the internet is not 100% accurate??? First it was television and now this?!?!?!?!? What next? Pretty soon you are going to tell me that politicians make up stories just to get elected.

_______________________________________________________________

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/

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 13

Sean Lange (2/15/2016)
Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...
I would be totally overjoyed.
I always tell people to verify and test anything that they take from the internet. I am not nearly vain enough to think that I should be the exception to that rule.
Really, I wish more people would get into the habit of taking the internet with a healthy dose of salt.
Come on. People don't put stuff up there if it's not true.
Now wait just a minute here...are you telling me that everything on the internet is not 100% accurate??? First it was television and now this?!?!?!?!? What next? Pretty soon you are going to tell me that politicians make up stories just to get elected.

Politicians don't make up stories... they actually believe their LOS is true.

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

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 14

Sean Lange (2/15/2016)
Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...
I would be totally overjoyed.
I always tell people to verify and test anything that they take from the internet. I am not nearly vain enough to think that I should be the exception to that rule.
Really, I wish more people would get into the habit of taking the internet with a healthy dose of salt.
Come on. People don't put stuff up there if it's not true.
Now wait just a minute here...are you telling me that everything on the internet is not 100% accurate??? First it was television and now this?!?!?!?!? What next? Pretty soon you are going to tell me that politicians make up stories just to get elected.

Time to exit the bubble Sean, not everything is what it seems out there;-)

😎

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

Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
I can see how some might take that as a "you distrust *MY* copious knowledge of this?" insult. I'm kind of expecting the answers to this to be more on the lines of "Oh thank heavens someone who doesn't just blindly accept what some random person on the Internet told them," but just in case...
On another note, for those in the US who happen to work in an industry that is affected, Happy Presidents day!
For those who still have to work today, well, been there, done that...
I would be totally overjoyed.
I always tell people to verify and test anything that they take from the internet. I am not nearly vain enough to think that I should be the exception to that rule.
Really, I wish more people would get into the habit of taking the internet with a healthy dose of salt.
Come on. People don't put stuff up there if it's not true.

I know, Grant. I know. It's not the people that do that, it's the aliens.

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/