Where's the Thread?

Question

Where's the Thread?

Viewing 15 posts - 31 through 45 (of 49 total)

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

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

Maybe The Thread just took some days off to enjoy some BBQ. 😀

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

andrew gothard SSChampion Points: 12314 More actions · Answer 2

Koen Verbeeck (9/22/2014)
I guess there was too much talk about Bbq in the thread and it just walked away. Or it was highjacked by a vegetarian action group.

nowt to do with me Guv'

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.

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

Steve Jones - SSC Editor

SSC Guru

Points: 736222

September 22, 2014 at 9:04 am

#1747127

It's back

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

GilaMonster (9/22/2014)
Maybe someone accidentally the Thread while cleaning up the weekend's spam (all 8 odd pages of it)

Yep. I'll post a blob about it, but long TL;DR, when cleaning spam, you can select a page of posts and whack them. For most of the forums, this has worked well on weekends since I (or any admin at RG) can look at the list, see the spam going from top to bottom, and delete them.

However I was doing this at the SQL Saturday, after prepping my session and killing a few minutes. The spammers started posted in the "Anything not aboutSQL" forum, and since all of you post so often, THE thread popped up in the middle and I didn't notice it.

Took until early am today, GMT, to get the restore. We use Rackspace and I don't have access or rights to request a restore from the RS people (it goes through some service on their side, CommVault), so I had to wait. I might have escalated it in other situations, but this wasn't critical enough to ruin someone's weekend.

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

Steve Jones - SSC Editor (9/22/2014)
It's back

Can I get my lost points back? :crying:

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

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

Not sure about the negative points. I suspect it's related, but no time to dig in this am. I'll let the sync job run in an hour or so and see if that clears things up.

WayneS SSC Guru Points: 95460 More actions · Answer 7

GilaMonster (9/22/2014)
Steve Jones - SSC Editor (9/22/2014)
It's back
Can I get my lost points back? :crying:

Steve just made an opportunity for you... how many people get to 40k points... twice?

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

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

Points will likely come when the sync job runs. We have issues at times with points not recording for threads, so we have a job to re-calculate them based on actual posts.

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

Steve Jones - SSC Editor (9/22/2014)
Not sure about the negative points. I suspect it's related, but no time to dig in this am. I'll let the sync job run in an hour or so and see if that clears things up.

I've seen points go negative when a thread is deleted, usually when I report something as spam. The negative points from The Thread haven't come back yet though.

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 10

Steve Jones - SSC Editor (9/22/2014)
I might have escalated it in other situations, but this wasn't critical enough to ruin someone's weekend.

We're talking about THE thread here!

Just kidding, thanks for all the effort done.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

HanShi SSC-Dedicated Points: 33507 More actions · Answer 11

Steve Jones - SSC Editor (9/22/2014)...... I might have escalated it in other situations, but this wasn't critical enough to ruin someone's weekend.

Now that's an attidude I wish other departments in my company had. That would save some nights sleep 😉

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 12

I'm kind of hoping this becomes the new thread. Yes, we'll lose the high count, but it won't have a title that might put people off any more. I don't know if less curmudgeonly is the way we want to go though.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 13

Stefan Krzywicki (9/22/2014)
I'm kind of hoping this becomes the new thread. Yes, we'll lose the high count, but it won't have a title that might put people off any more. I don't know if less curmudgeonly is the way we want to go though.

You want this to becomes multi-threaded? 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

Alvin Ramard (9/22/2014)
Stefan Krzywicki (9/22/2014)
I'm kind of hoping this becomes the new thread. Yes, we'll lose the high count, but it won't have a title that might put people off any more. I don't know if less curmudgeonly is the way we want to go though.
You want this to becomes multi-threaded? 😀

For now, maxdop = 2

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

TomThomson SSC Guru Points: 104773 More actions · Answer 15

Stefan Krzywicki (9/22/2014)
I'm kind of hoping this becomes the new thread.

Ah, all becomes clear. The thread wanted a companion, so it inserted itself between some spam threads to fool Steve into deleting temporarily it so that a new thread would be born.

Tom