Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 46,861 through 46,875 (of 66,712 total)

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

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

SQLRNNR (1/7/2015)
So, just a point of curiosity.
Will there ever be a fix for that snafu a bit back that obliterated points for a bunch of threadizens?

Heh... nah... just renenter all the posts. 😉

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

rodjkidd SSCoach Points: 15916 More actions · Answer 2

Hello all,

Just caught up with the thread. Was away for Christmas then experienced New years Eve in London. basically it takes 2 hours longer to get back! So got home at 4:15. Should have booked a hotel, but it was last minute. Oh did I forget I drove down from North Scotland as well that day? Near Aberdeen. Mad utterly mad...

Then took me 2 days more or less to get back on normal time due all of that!

So...

Happy New Year All!

Gianluca massive congrats on the MVP.

Lynn - hope the remaining days fly by uneventful and we will have to meet in person at the Summit seeing as you are going... yay!

Dwain - good luck with the house move...

Um, have I forgot anyone, anything? 🙂

Me? Well last contract ended at the end of the year, so looking for a new 'gig'. Just had a few days off the radar so to speak to try and catch up with all that stuff that you get behind with when working away.

Taking of PASS...

I pretty much know where I'll be staying - probably the Hilton nearby. Hopefully I can get a good price this week as they have a sale... And maybe the flights as well as there are 'sales' on now as well.

But I do know someone who is going for the first time and doesn't want to pay the price for the recommended hotels. Everyone I know stayed in one of the main hotels last year and it was my first Summit in Seattle, so I didn't know what to suggest. So for those who have been before, if you'd all like to throw some suggestions my way I can pass them on.

Cheers,

Rodders...

Dwain Camps SSC Guru Points: 86948 More actions · Answer 3

rodjkidd (1/7/2015)
Hello all,
Just caught up with the thread. Was away for Christmas then experienced New years Eve in London. basically it takes 2 hours longer to get back! So got home at 4:15. Should have booked a hotel, but it was last minute. Oh did I forget I drove down from North Scotland as well that day? Near Aberdeen. Mad utterly mad...
Then took me 2 days more or less to get back on normal time due all of that!
So...
Happy New Year All!
Gianluca massive congrats on the MVP.
Lynn - hope the remaining days fly by uneventful and we will have to meet in person at the Summit seeing as you are going... yay!
Dwain - good luck with the house move...
Um, have I forgot anyone, anything? 🙂
Me? Well last contract ended at the end of the year, so looking for a new 'gig'. Just had a few days off the radar so to speak to try and catch up with all that stuff that you get behind with when working away.
Taking of PASS...
I pretty much know where I'll be staying - probably the Hilton nearby. Hopefully I can get a good price this week as they have a sale... And maybe the flights as well as there are 'sales' on now as well.
But I do know someone who is going for the first time and doesn't want to pay the price for the recommended hotels. Everyone I know stayed in one of the main hotels last year and it was my first Summit in Seattle, so I didn't know what to suggest. So for those who have been before, if you'd all like to throw some suggestions my way I can pass them on.
Cheers,
Rodders...

Thanks Rodders!

Speaking of Lynn, where's that countdown?

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

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

dwain.c (1/7/2015)
rodjkidd (1/7/2015)
Hello all,
Just caught up with the thread. Was away for Christmas then experienced New years Eve in London. basically it takes 2 hours longer to get back! So got home at 4:15. Should have booked a hotel, but it was last minute. Oh did I forget I drove down from North Scotland as well that day? Near Aberdeen. Mad utterly mad...
Then took me 2 days more or less to get back on normal time due all of that!
So...
Happy New Year All!
Gianluca massive congrats on the MVP.
Lynn - hope the remaining days fly by uneventful and we will have to meet in person at the Summit seeing as you are going... yay!
Dwain - good luck with the house move...
Um, have I forgot anyone, anything? 🙂
Me? Well last contract ended at the end of the year, so looking for a new 'gig'. Just had a few days off the radar so to speak to try and catch up with all that stuff that you get behind with when working away.
Taking of PASS...
I pretty much know where I'll be staying - probably the Hilton nearby. Hopefully I can get a good price this week as they have a sale... And maybe the flights as well as there are 'sales' on now as well.
But I do know someone who is going for the first time and doesn't want to pay the price for the recommended hotels. Everyone I know stayed in one of the main hotels last year and it was my first Summit in Seattle, so I didn't know what to suggest. So for those who have been before, if you'd all like to throw some suggestions my way I can pass them on.
Cheers,
Rodders...
Thanks Rodders!
Speaking of Lynn, where's that countdown?

Post it closer to the end of my shift. Still have about 30 minutes.

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

... Mark one off, 51 days on the calendar to go. 51 days on the calendar to go, 51 days to go, ...

Dwain Camps SSC Guru Points: 86948 More actions · Answer 6

Lynn Pettis (1/7/2015)
... Mark one off, 51 days on the calendar to go. 51 days on the calendar to go, 51 days to go, ...

I feel much better now...

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

dwain.c (1/7/2015)
Lynn Pettis (1/7/2015)
... Mark one off, 51 days on the calendar to go. 51 days on the calendar to go, 51 days to go, ...
I feel much better now...

Alas, everything gets set right in the universe with that post. Yay:cool:

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

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

Stefan Krzywicki (1/7/2015)
SQLRNNR (1/7/2015)
Stefan Krzywicki (1/7/2015)
Steve Jones - SSC Editor (1/7/2015)
Ahhh, the cloud... http://www.computerworld.com/article/2865802/verizon-warns-enterprise-cloud-users-of-48-hour-shutdown.html
Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure I had access during the outage" I'd be looking for new providers and rethinking my own data center.
I agree.
I have a client using Azure that recently experienced a 12+hr outage (caused by Azure maintenance) and they were considering alternatives. That is a long time.
Really! Huh. I'm surprised MS didn't make it invisible by shifting them around.

They do.

If we're thinking of the same one, it was a mistake. The maintenance, instead of rolling across the data centers as it should have, applied to everything at the same time.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 9

Are the spammers getting worse?

Fight fire with fire: let's spam their contact form!

-- Gianluca Sartori

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

It's probably not that site posting SPAM, but someone with an affiliate code, or perhaps just a vandal.

spaghettidba SSC Guru Points: 105732 More actions · Answer 11

Steve Jones - SSC Editor (1/8/2015)
It's probably not that site posting SPAM, but someone with an affiliate code, or perhaps just a vandal.

Maybe. Meanwhile, no response from them yet.

-- Gianluca Sartori

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 12

spaghettidba (1/8/2015)
Are the spammers getting worse?
Fight fire with fire: let's spam their contact form!

Now all you have to do is to create a SQL Job that posts random text to this form every few seconds:-D

😎

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

spaghettidba (1/8/2015)
Steve Jones - SSC Editor (1/8/2015)
It's probably not that site posting SPAM, but someone with an affiliate code, or perhaps just a vandal.
Maybe. Meanwhile, no response from them yet.

This is interesting.

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

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

Luis Cazares (1/8/2015)
spaghettidba (1/8/2015)
Steve Jones - SSC Editor (1/8/2015)
It's probably not that site posting SPAM, but someone with an affiliate code, or perhaps just a vandal.
Maybe. Meanwhile, no response from them yet.
This is interesting.

Yeah it is. Our WebSense filter lets me through. Either way, it probably isn't worth hitting them. We don't want to stoop to their level.

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 15

Luis Cazares (1/8/2015)
spaghettidba (1/8/2015)
Steve Jones - SSC Editor (1/8/2015)
It's probably not that site posting SPAM, but someone with an affiliate code, or perhaps just a vandal.
Maybe. Meanwhile, no response from them yet.
This is interesting.

FYI

😎

WHOIS:

Domain name:

exdisplaykitchens1.co.uk

Registrant:

Laura Digweed

Registrant type:

UK Individual

Registrant's address:

9 Heald Close

Manchester

OL12 7HJ

United Kingdom

Data validation:

Registrant contact details validated by Nominet on 24-Jun-2013

Registrar:

Mesh Digital Limited t/a Domainmonster.com [Tag = MONSTER]

URL: http://www.domainmonster.com

Relevant dates:

Registered on: 11-Mar-2013

Expiry date: 11-Mar-2015

Last updated: 27-Aug-2014

Registration status:

Registered until expiry date.

Name servers:

ns1.nservers.co.uk 77.243.190.55

ns2.nservers.co.uk 77.243.190.55

ns3.nservers.co.uk 77.243.190.55

WHOIS lookup made at 19:32:09 08-Jan-2015