Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 58,201 through 58,215 (of 66,712 total)

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

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 1

jasona.work - Wednesday, April 19, 2017 10:51 AM
Well, originally I'd wanted to name my new production servers Larry, Moe, Curly, and Shemp...
QA would've been Pinky and Brain...
*SNARF*

I used to work at a company back in the late 90's where the production database server (Interbase 4) was actually named Nemesis. Needless to say, it would crash 2 or 3 times a day :angry: I was very glad to help them forklift the system to Oracle 8i.

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

ThomasRushton - Wednesday, April 19, 2017 8:34 AM
Grant Fritchey - Wednesday, April 19, 2017 8:27 AM
Brandie Tarvin - Wednesday, April 19, 2017 7:40 AM
So what hotels have you been staying at lately?
http://www.bbc.com/news/technology-39642172
Yikes. I stayed at a Holiday Inn for the first time in years just a couple of weeks ago. Luckily it was in Telford and this seems to all be in the US. Dodged a bullet.
That's got to be the first time somebody was considering themselves lucky to have been staying in a Holiday Inn in Telford...

Tell that to the people staying at the Premier Inn in Telford.

"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

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

Grant Fritchey - Wednesday, April 19, 2017 8:27 AM
Brandie Tarvin - Wednesday, April 19, 2017 7:40 AM
So what hotels have you been staying at lately?
http://www.bbc.com/news/technology-39642172
Yikes. I stayed at a Holiday Inn for the first time in years just a couple of weeks ago. Luckily it was in Telford and this seems to all be in the US. Dodged a bullet.

No Holiday Inn here. Very nice guest house instead.
I can't recall the last time I stayed in a Holiday Inn.

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

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 4

GilaMonster - Wednesday, April 19, 2017 12:22 PM
Grant Fritchey - Wednesday, April 19, 2017 8:27 AM
Brandie Tarvin - Wednesday, April 19, 2017 7:40 AM
So what hotels have you been staying at lately?
http://www.bbc.com/news/technology-39642172
Yikes. I stayed at a Holiday Inn for the first time in years just a couple of weeks ago. Luckily it was in Telford and this seems to all be in the US. Dodged a bullet.
No Holiday Inn here. Very nice guest house instead.
I can't recall the last time I stayed in a Holiday Inn.

She had left me with only my pipe and piano, playing the bells on the tree with the pipe stem in my misery. Of all the gin joints in all the world, she had to walk out of mine.....

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

jasona.work - Wednesday, April 19, 2017 10:25 AM
Brandie Tarvin - Wednesday, April 19, 2017 9:03 AM
Grrrr. I hate blackbox server names.
Me: Is FTP connection XYZ affected by your login / password changes
Corporate: What's the path?
Me: Umm, XYZ is the only name I have. I don't have remote access to the site. I just know a file gets sent and magic happens to load it to your systems.
Corporate: But what's the path?
*headdesk*
I was joking with a co-worker yesterday about naming servers with valid IP addresses, but not the actual IP of the server itself...
I can mentally hear the conversation:
A: Hey, is 192.168.1.11 down?
B: I dunno, can you ping it from 10.10.10.21?
A: Hang on, let me log into 10.10.10.21 and try.
Now I want to try this at home...

Oy vey. Why not add an alias (with another ip address) in there for that too?

Or why not try it with IPV6 addresses?

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

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

Lynn Pettis - Wednesday, April 19, 2017 11:51 AM
Well, SSC is a great site. I saw a response to a question, contacted the respondent by PM, and it paid off. Paul Stanton has accepted an invitation to speak at the Boulder, Colorado Springs, and Denver SQL Server Users Group meetings in September. He is the VP Cloud and Products at Windocks.
Thank you, Steve, for having such a wonderful site that can actually help in many ways.

cheers

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 7

jasona.work - Wednesday, April 19, 2017 10:51 AM
Brandie Tarvin - Wednesday, April 19, 2017 10:42 AM
jasona.work - Wednesday, April 19, 2017 10:25 AM
Brandie Tarvin - Wednesday, April 19, 2017 9:03 AM
Grrrr. I hate blackbox server names.
Me: Is FTP connection XYZ affected by your login / password changes
Corporate: What's the path?
Me: Umm, XYZ is the only name I have. I don't have remote access to the site. I just know a file gets sent and magic happens to load it to your systems.
Corporate: But what's the path?
*headdesk*
I was joking with a co-worker yesterday about naming servers with valid IP addresses, but not the actual IP of the server itself...
I can mentally hear the conversation:
A: Hey, is 192.168.1.11 down?
B: I dunno, can you ping it from 10.10.10.21?
A: Hang on, let me log into 10.10.10.21 and try.
Now I want to try this at home...
And when you both leave the company with no documentation left behind, the logic bomb you've planted will explode in someone's face and cause all sorts of mayhem.
Congrats. We have officially gone full circle on that question. @=)
Well, originally I'd wanted to name my new production servers Larry, Moe, Curly, and Shemp...
QA would've been Pinky and Brain...
*SNARF*

I think I saw Animaniacs on Amazon Prime, have to check that again now that I'm out of school

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

jonathan.crawford - Wednesday, April 19, 2017 3:01 PM
jasona.work - Wednesday, April 19, 2017 10:51 AM
Brandie Tarvin - Wednesday, April 19, 2017 10:42 AM
jasona.work - Wednesday, April 19, 2017 10:25 AM
Brandie Tarvin - Wednesday, April 19, 2017 9:03 AM
Grrrr. I hate blackbox server names.
Me: Is FTP connection XYZ affected by your login / password changes
Corporate: What's the path?
Me: Umm, XYZ is the only name I have. I don't have remote access to the site. I just know a file gets sent and magic happens to load it to your systems.
Corporate: But what's the path?
*headdesk*
I was joking with a co-worker yesterday about naming servers with valid IP addresses, but not the actual IP of the server itself...
I can mentally hear the conversation:
A: Hey, is 192.168.1.11 down?
B: I dunno, can you ping it from 10.10.10.21?
A: Hang on, let me log into 10.10.10.21 and try.
Now I want to try this at home...
And when you both leave the company with no documentation left behind, the logic bomb you've planted will explode in someone's face and cause all sorts of mayhem.
Congrats. We have officially gone full circle on that question. @=)
Well, originally I'd wanted to name my new production servers Larry, Moe, Curly, and Shemp...
QA would've been Pinky and Brain...
*SNARF*
I think I saw Animaniacs on Amazon Prime, have to check that again now that I'm out of school

Because we are all a little tiny and a whole lotta looney

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

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

Any bets that the OP in this topic: https://www.sqlservercentral.com/Forums/1871933/SQL-Server-detected-a-logical-consistencybased-IO-error-incorrect-checksum is now cursing "that person on the internet that *told* me to do the repair" right now?

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

jasona.work - Thursday, April 20, 2017 12:15 PM
Any bets that the OP in this topic: https://www.sqlservercentral.com/Forums/1871933/SQL-Server-detected-a-logical-consistencybased-IO-error-incorrect-checksum is now cursing "that person on the internet that *told* me to do the repair" right now?

Wow. I thought Gail was beyond clear when the OP referred to a "suggestion" and they come back "okay, I'll do it". I can't believe the OP has privs to do it in the first place.

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

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

Ed Wagner - Thursday, April 20, 2017 12:33 PM
jasona.work - Thursday, April 20, 2017 12:15 PM
Any bets that the OP in this topic: https://www.sqlservercentral.com/Forums/1871933/SQL-Server-detected-a-logical-consistencybased-IO-error-incorrect-checksum is now cursing "that person on the internet that *told* me to do the repair" right now?
Wow. I thought Gail was beyond clear when the OP referred to a "suggestion" and they come back "okay, I'll do it". I can't believe the OP has privs to do it in the first place.

The story has a happy ending, though.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Hugo Kornelis - Monday, April 17, 2017 10:18 AM
JustMarie - Monday, April 17, 2017 9:44 AM
Does anyone else think GeorgeCopeland was having a bad day? Or does he really not get the fact that there's a lot of dirty data out there and this IS a problem that people need to consider?
https://www.sqlservercentral.com/Forums/FindPost1870780.aspx
I don't know how George sounds when he's having goood or bad days. But I do agree with him.
Yes, there is dirty data out there. But the article makes it sound as if the author found a bug ("but this result is wrong based on the fact that 1/1/1900 is not the date you expect to see and use as the outcome" - emphasis mine). That's not the case. The behaviour observed in the article is well documented, and even easy to understand when you consider that datetime and smalldatetime predate the newer date and time datatypes. Before SQL Server 2005, these data types were the only ption for storing dates (and accepting the default time part of midnight) or for storing times (and accepting the default date part of 1-1-1900).
The issue described in the article is not at all related to an issue with the datetime data type, it is related to an issue with improper usage of the datetime data type. My guess is that this is what George is trying to explain (in a more blunt and direct manner than I would have done).

It isn't a bug in the implementation of SQL Server's SQL, but in any data acquisition system for data that requires real datetime data amd doesn't ensure that the data acquired provieds the correct year part of the datetime certainly has a bug, and some sort of detection of erroneous data and/or some sort of workaround is required when using that data. Only an idiot thinks that providing default values without any indicating that they are just defaults with no valid meaning rather than correct valid data is sensible behaviour (and yes, I do I do think CJD was idiotic on that topic).

Tom

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

Gotta love when you're poking through a SQL install log trying to figure out why it failed, and you find a line with this in it:

Hello, I'm your 64bit Impersonated custom action server.

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

Here is new twist to bobby tables...of course it is syntactically all sorts of not going to work but still pretty funny.

_______________________________________________________________

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/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Sean Lange - Friday, April 21, 2017 8:07 AM
Here is new twist to bobby tables...of course it is syntactically all sorts of not going to work but still pretty funny.

I like it.

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