Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 61,861 through 61,875 (of 66,000 total)

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

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 1

Jeff Moden - Thursday, July 19, 2018 6:51 AM

Lynn Pettis - Wednesday, July 18, 2018 4:04 PM

This is really getting ridiculous. Why is it so hard for people to actual do some thinking instead of having things handed to them? And yes, I gave in and did it. Arg!

I won't "pile on" but I am curious... what's the link you're speaking of?

https://qa.sqlservercentral.com/Forums/1977309/Need-help-with-the-getting-a-top-1-record-with-in-a-table-with-same-ids#bm1977338

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

Heh... inline with the first interview question about how to get the current date and time, perhaps this should be the second question...
https://qa.sqlservercentral.com/Forums/FindPost1977357.aspx

I have to admit, it's sometimes difficult to not bloody my head by doing a major head-desk. 😀 It's no wonder that a lot of DBAs brew their own beer... they need a constant supply to avoid the head-desk syndrome. 😀

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

Lynn Pettis - Thursday, July 19, 2018 8:32 AM

Jeff Moden - Thursday, July 19, 2018 6:51 AM

Lynn Pettis - Wednesday, July 18, 2018 4:04 PM

This is really getting ridiculous. Why is it so hard for people to actual do some thinking instead of having things handed to them? And yes, I gave in and did it. Arg!

I won't "pile on" but I am curious... what's the link you're speaking of?

https://qa.sqlservercentral.com/Forums/1977309/Need-help-with-the-getting-a-top-1-record-with-in-a-table-with-same-ids#bm1977338

Heh... I've been playing the part of a terrorist on that one... "Bin Watchin'". 😀

--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)
Intro to Tally Tables and Functions

Eirikur Eiriksson SSC Guru Points: 182631 More actions · Answer 4

Eirikur Eiriksson

SSC Guru

Points: 182631

July 19, 2018 at 8:53 am

#1998220

Jeff Moden - Thursday, July 19, 2018 8:47 AM

Heh... I've been playing the part of a terrorist on that one... "Bin Watchin'". 😀

Think you need to run your "S--p--e--l--l i--t o--u--t" function on that answer.
😎

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

Eirikur Eiriksson - Thursday, July 19, 2018 8:53 AM

Think you need to run your "S--p--e--l--l i--t o--u--t" function on that answer.
😎

"Look with eye" made me laugh out loud - but man, how accurate!

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

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 6

Lynn Pettis

SSC Guru

Points: 442447

July 19, 2018 at 9:48 am

#1998240

ChrisM@Work - Thursday, July 19, 2018 8:58 AM

"Look with eye" made me laugh out loud - but man, how accurate!

And he still did it wrong.

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 7

ChrisM@Work - Thursday, July 19, 2018 8:58 AM

"Look with eye" made me laugh out loud - but man, how accurate!

Technically that's a misquote. Pretty sure Mr Myiagi (the senior DBA of course) stated "Look eye".

Still - bonus points for a perfect context in which to use the quote:D

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 8

Now this is just a little bit scary from someone who has been around SQL Server for 16 years: https://qa.sqlservercentral.com/Forums/FindPost1977555.aspx.

Or it could just be me, but I was learning about the system tables and views when I first started working with SQL Server. Maybe not all of them but I knew they existed and where to find more information.

Sean Lange SSC Guru Points: 286562 More actions · Answer 9

Lynn Pettis - Thursday, July 19, 2018 1:45 PM

Now this is just a little bit scary from someone who has been around SQL Server for 16 years: https://qa.sqlservercentral.com/Forums/FindPost1977555.aspx.

Or it could just be me, but I was learning about the system tables and views when I first started working with SQL Server. Maybe not all of them but I knew they existed and where to find more information.

OH MY!!!!

_______________________________________________________________

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/

Thom A SSC Guru Points: 99009 More actions · Answer 10

Sean Lange - Thursday, July 19, 2018 1:51 PM

OH MY!!!!

I think it's more telling that for someone who has been working with SQL Server for a long time, and didn't understand something that was (very) likely to be documented, their first action was to just ask the on a forum rather that research and learn about it themselves.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

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

Thom A - Friday, July 20, 2018 1:44 AM

I think it's more telling that for someone who has been working with SQL Server for a long time, and didn't understand something that was (very) likely to be documented, their first action was to just ask the on a forum rather that research and learn about it themselves.

Here's where those types of people come from...
https://qa.sqlservercentral.com/Forums/1977780/sql-server-2014-queries

I can't believe that there's no shame and no pride on the part of the OP in doing something like this. I knew the world was getting worse but didn't realize just how bad it's gotten.

Heh... I wonder if he knows how to get the current date and time? 😀

And no need to pile on. I just wanted you to see it because I was totally gob smacked at the shear audacity of it all not to mention the total lack of personal ethics that just asking such a question represents.

--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)
Intro to Tally Tables and Functions

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 12

Jeff Moden - Friday, July 20, 2018 5:32 PM

Here's where those types of people come from...
https://qa.sqlservercentral.com/Forums/1977780/sql-server-2014-queries

I can't believe that there's no shame and no pride on the part of the OP in doing something like this. I knew the world was getting worse but didn't realize just how bad it's gotten.

Heh... I wonder if he knows how to get the current date and time? 😀

And no need to pile on. I just wanted you to see it because I was totally gob smacked at the shear audacity of it all not to mention the total lack of personal ethics that just asking such a question represents.

SMDH

jasona.work SSC Guru Points: 50021 More actions · Answer 13

Jeff Moden - Friday, July 20, 2018 5:32 PM

Here's where those types of people come from...
https://qa.sqlservercentral.com/Forums/1977780/sql-server-2014-queries

I can't believe that there's no shame and no pride on the part of the OP in doing something like this. I knew the world was getting worse but didn't realize just how bad it's gotten.

Heh... I wonder if he knows how to get the current date and time? 😀

And no need to pile on. I just wanted you to see it because I was totally gob smacked at the shear audacity of it all not to mention the total lack of personal ethics that just asking such a question represents.

That...
That was horrifying...
Half the time you can almost smell if a question is going to be someone's homework just from the title of the topic...
But that has new levels of "not even trying to pass of a homework question as my own work"
Honestly, *pictures* of the questions, not even trying to re-type them in their own words?
Sheesh...

Sean Lange SSC Guru Points: 286562 More actions · Answer 14

jasona.work - Monday, July 23, 2018 7:28 AM

That...
That was horrifying...
Half the time you can almost smell if a question is going to be someone's homework just from the title of the topic...
But that has new levels of "not even trying to pass of a homework question as my own work"
Honestly, *pictures* of the questions, not even trying to re-type them in their own words?
Sheesh...

And then the total bullshit piece of "I am an Oracle person, just need to learn this in sql server". What a total crock. Joins work the same in both with identical syntax. Sad...

_______________________________________________________________

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/

Luis Cazares SSC Guru Points: 183686 More actions · Answer 15

Sean Lange - Monday, July 23, 2018 7:48 AM

jasona.work - Monday, July 23, 2018 7:28 AM

Jeff Moden - Friday, July 20, 2018 5:32 PM

Thom A - Friday, July 20, 2018 1:44 AM

I think it's more telling that for someone who has been working with SQL Server for a long time, and didn't understand something that was (very) likely to be documented, their first action was to just ask the on a forum rather that research and learn about it themselves.

Here's where those types of people come from...
https://qa.sqlservercentral.com/Forums/1977780/sql-server-2014-queries

I can't believe that there's no shame and no pride on the part of the OP in doing something like this. I knew the world was getting worse but didn't realize just how bad it's gotten.

Heh... I wonder if he knows how to get the current date and time? 😀

And no need to pile on. I just wanted you to see it because I was totally gob smacked at the shear audacity of it all not to mention the total lack of personal ethics that just asking such a question represents.

That...
That was horrifying...
Half the time you can almost smell if a question is going to be someone's homework just from the title of the topic...
But that has new levels of "not even trying to pass of a homework question as my own work"
Honestly, *pictures* of the questions, not even trying to re-type them in their own words?
Sheesh...

And then the total bullshit piece of "I am an Oracle person, just need to learn this in sql server". What a total crock. Joins work the same in both with identical syntax. Sad...

There are 2 main thing that would be different, probably 3 depending on how some people code.
1. Parameter definition (syntax and types)
2. Using a tally table to get all the dates in a year.
3. Not having natural joins in T-SQL

However, someone that actually knows how to write SQL code, shouldn't have much problem coming out with some sort of solution.

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