Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,336 through 55,350 (of 66,712 total)

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

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

ThomasRushton (8/15/2016)
Jeff Moden (8/15/2016)
ThomasRushton (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.
I wonder if there's a way to find the post and resurrect it?
I saw a couple of Bob Hovious' (hope I remembered how to spell his last name) posts get whacked. Damned automatic spam detection is whacking good posts and letting spam through. The same happened to me a couple of months ago.
It could be an artefact of the spam-handling process when dealing with a single spammy post on a hammy topic / thread. The UI for dealing with these things manually isn't brilliant either.
This is also why I'm not a fan of supposed "machine learning" except maybe for search-engine suggestions. I'd rather see the "captcha" thing for new members, instead. That would slow down the bots and the people doing the spamming. If it came to it, I'd even use "captcha" for posts to make it less possible for bots.
+1 for captcha. Machine-learning has its place, but machine rules can be too heavy-handed as well - we regularly have occurrences of high-ranking contributors on AskSSC getting blocked due to the repetition rules in the anti-spam function there.

As long as the captcha is one that uses a readable display, count my vote in favor. There are some that are just plain illegible.

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

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

Hey Threadizens!

India was lovely, terrifying, interesting, frustrating and great, all at once. I've taken more selfies with people on this one trip than I had done in my entire life up to this point.

Did I miss anything outstanding, cause I've just been deleting my alert emails for a week.

"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

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 3

Grant Fritchey (8/15/2016)
Hey Threadizens!

Grant!

Damn. Now I want to watch some Cheers.

Thomas Rushton
blog: https://thelonedba.wordpress.com

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

ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!
Grant!
Damn. Now I want to watch some Cheers.

Gosh never mind the telly, where's the best curry around here?

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

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 5

ChrisM@Work (8/15/2016)
ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!
Grant!
Damn. Now I want to watch some Cheers.
Gosh never mind the telly, where's the best curry around here?

It depends. (sorrynotsorry).

Where are you? What distance counts as "around here"?

Thomas Rushton
blog: https://thelonedba.wordpress.com

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

ThomasRushton (8/15/2016)
ChrisM@Work (8/15/2016)
ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!
Grant!
Damn. Now I want to watch some Cheers.
Gosh never mind the telly, where's the best curry around here?
It depends. (sorrynotsorry).
Where are you? What distance counts as "around here"?

Food there was amazing. Lamb was hard to find though. Most of the meat, what there was of it, was chicken.

"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

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

ThomasRushton (8/15/2016)
ChrisM@Work (8/15/2016)
ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!
Grant!
Damn. Now I want to watch some Cheers.
Gosh never mind the telly, where's the best curry around here?
It depends. (sorrynotsorry).
Where are you? What distance counts as "around here"?

Piccadilly, London - and there are certainly some good ones within walking distance including Chutney Mary[/url].

Just as an aside, can you imaging trying to stay awake with a bellyful of rich curry on a warm day with feeble AC in the office?

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

Steve Jones - SSC Editor SSC Guru Points: 736222 More actions · Answer 8

ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.

Any more details? I don't see anything with a portion of that text. Tried '%miles out%' and nothing. Other than the 5 or 6 that you all have posted/quoted.

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

Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.
Any more details? I don't see anything with a portion of that text. Tried '%miles out%' and nothing. Other than the 5 or 6 that you all have posted/quoted.

Sorry Steve, "miles out" was miles out 🙂

The same post went up in several places on Saturday morning with what looks like the same wording. Try this one.

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

Steve Jones - SSC Editor SSC Guru Points: 736222 More actions · Answer 10

ChrisM@Work (8/15/2016)
Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.
Any more details? I don't see anything with a portion of that text. Tried '%miles out%' and nothing. Other than the 5 or 6 that you all have posted/quoted.
Sorry Steve, "miles out" was miles out 🙂
The same post went up in several places on Saturday morning with what looks like the same wording. Try this one.

K, will look more shortly.

Steve Jones - SSC Editor SSC Guru Points: 736222 More actions · Answer 11

Jeff Moden (8/15/2016)
I saw a couple of Bob Hovious' (hope I remembered how to spell his last name) posts get whacked. Damned automatic spam detection is whacking good posts and letting spam through. The same happened to me a couple of months ago.
This is also why I'm not a fan of supposed "machine learning" except maybe for search-engine suggestions. I'd rather see the "captcha" thing for new members, instead. That would slow down the bots and the people doing the spamming. If it came to it, I'd even use "captcha" for posts to make it less possible for bots.

The machine learning feedback isn't quite working. More of a setup for us.

The algorithms go get better, but they require care and feeding. It's less the technology, and more us. Though if you expect perfection that's not going to happen. Captcha or other ML work. That's the nature of the way in which humans battle machines.

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

ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.

This?

http://www.sqlservercentral.com/Forums/Topic1809360-3412-1.aspx

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

Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.
This?
http://www.sqlservercentral.com/Forums/Topic1809360-3412-1.aspx

Bang on.

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

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

ChrisM@Work (8/15/2016)
Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.
This?
http://www.sqlservercentral.com/Forums/Topic1809360-3412-1.aspx
Bang on.

Excellent

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 15

Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had noticed the change in behaviour of the CE concerning IF EXISTS() queries and was looking for an explanation. This particular change in behaviour was covered by one of the talks at the last SQL Bits so I knew enough about it to be able to Google for a decent reference. It wasn’t until Sunday evening that the opportunity came up to revisit the post, by which time it had disappeared.
This?
http://www.sqlservercentral.com/Forums/Topic1809360-3412-1.aspx
Bang on.
Excellent

And thus, inevitably and eternally..... SPAM

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills