Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 62,941 through 62,955 (of 66,712 total)

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

x SSC-Insane Points: 23660 More actions · Answer 1

heh you're probably better than this guy!
https://www.youtube.com/watch?v=OMceVbo3Tm4

heh just kidding, the guy isn't really all THAT bad a shot 😀

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

patrickmcginnis59 10839 - Thursday, January 10, 2019 11:04 AM
heh you're probably better than this guy!
https://www.youtube.com/watch?v=OMceVbo3Tm4
heh just kidding, the guy isn't really all THAT bad a shot 😀

Hah!
Great clip. And I'm afraid I could do the exact same with a real snooker table....

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

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

Hugo Kornelis - Thursday, January 10, 2019 10:09 AM
Thanks, Chris!
I tried to contribute for your Isle of Wight challenge but I had to give up. Made two tries, both times I got an error after entering my credit card details and the authorization codes. An error without further explanation as to why.
Are there any other ways for me to contribute? (I don't have a personal PayPal account so that's not an option)

Hey Hugo, you're welcome. To be honest, I'd much rather walk around the coastline of a scenic island in late spring than attempt to play snooker for 24 hours!
I'm sorry you've experienced problems donating. We've now accumulated numerous donations from within and outside the UK so I suspect it was an early glitch in the provider's software. We've noticed a few in other areas, particularly registration. Perhaps give it a few days and try again if you wish. As an alternative I'd suggest you join us, but we already have a native Dutch-speaking SQL Server expert on our team - he's the nutter doing the 13 mile offshore swim 🙂

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

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

Eirikur Eiriksson

SSC Guru

Points: 182911

January 15, 2019 at 3:47 am

#2018912

Just had to share this one
😎

drew.allen SSC Guru Points: 76985 More actions · Answer 5

I had to change my password at work today. I set it to a 12-character string with a mix of uppercase, lowercase, and numbers. When I came back from lunch, I was unable to log into my computer. I tried again making absolutely sure that I typed the password slowly to reduce potential typos. Still unable to log in. I ended up eventually locking my account and calling the help desk. It turns out the problem is that the password has to be exactly 8 characters. No more, no less.

First, why would anyone have a maximum password length set to 8 characters in this day and age? I can understand having a minimum, but not a maximum.

Second, when I enter a string that is too long, why does it not produce an error message?

Third, when you go to change the password, why doesn't it remind you what the policy is?

:crazy:

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Jonathan AC Roberts SSCoach Points: 18354 More actions · Answer 6

drew.allen - Tuesday, January 15, 2019 11:52 AM
I had to change my password at work today. I set it to a 12-character string with a mix of uppercase, lowercase, and numbers. When I came back from lunch, I was unable to log into my computer. I tried again making absolutely sure that I typed the password slowly to reduce potential typos. Still unable to log in. I ended up eventually locking my account and calling the help desk. It turns out the problem is that the password has to be exactly 8 characters. No more, no less.
First, why would anyone have a maximum password length set to 8 characters in this day and age? I can understand having a minimum, but not a maximum.
Second, when I enter a string that is too long, why does it not produce an error message?
Third, when you go to change the password, why doesn't it remind you what the policy is?
:crazy:
Drew

I've got a mainframe login that needs an 8 char password. It's not case sensitive though.

Michael L John One Orange Chip Points: 27055 More actions · Answer 7

Do you work at a financial institution? My bank will not allow more than 8 characters. Or, should I say, my former bank?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

drew.allen SSC Guru Points: 76985 More actions · Answer 8

I do work at a financial institution. Is there some sort of regulation that I'm not aware of?

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

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

Some of the bank security stuff is a total joke. I like how they ask you to add security questions and the options are stupid things that would be readily accessible through public record or easily discovered via social media. Things like, "your favorite food". Seriously? Anybody who knows me knows it is bacon. Or city where you were born? Because that would be challenging to figure out for somebody else. I end up using my password tool to track these stupid questions and provide completely false answers because the real answers would make my account less secure, not more.

_______________________________________________________________

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/

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

It doesn't matter what sector you work in - an 8 character max is just plain silly. It may be a PITA from time to time (at least for me), but lockout policies do work because they help to prevent brute force.

As for why the rule isn't enforced when you go to change your password, I'd have a talk with your domain admin (or whoever the enforcer is) about it. That's also flat-out silly and setting people up for failure.

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

drew.allen SSC Guru Points: 76985 More actions · Answer 11

Sean Lange - Tuesday, January 15, 2019 1:10 PM
Some of the bank security stuff is a total joke. I like how they ask you to add security questions and the options are stupid things that would be readily accessible through public record or easily discovered via social media. Things like, "your favorite food". Seriously? Anybody who knows me knows it is bacon. Or city where you were born? Because that would be challenging to figure out for somebody else. I end up using my password tool to track these stupid questions and provide completely false answers because the real answers would make my account less secure, not more.

Well, I have an advantage there. Drew is an alias, so any public record for "Drew Allen" will most likely refer to some other person and my legal name is so common it would be very difficult to match up a specific person with a specific birthplace.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

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

Wow, things are stressing.

Work seems to be stabilizing at the moment, but they are talking about pimping me out to other parts of Parson to support MS SQL.

That is good, I think.

The hard part is coming tonight when I go out to the hospital as dad and I will be meeting hospice. Not sure what is going on at this time other than dad saying last night was not a good night.

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

Lynn Pettis - Tuesday, January 15, 2019 5:45 PM
Wow, things are stressing.
Work seems to be stabilizing at the moment, but they are talking about pimping me out to other parts of Parson to support MS SQL.
That is good, I think.
The hard part is coming tonight when I go out to the hospital as dad and I will be meeting hospice. Not sure what is going on at this time other than dad saying last night was not a good night.

I'm not ready for this...â€¦â€¦...
Time to get a drink or ten.

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

Lynn Pettis - Tuesday, January 15, 2019 8:39 PM
I'm not ready for this...â€¦â€¦...
Time to get a drink or ten.

Okay, I only had two shots of Fireball Whiskey.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 15

Lynn Pettis - Tuesday, January 15, 2019 9:54 PM
Okay, I only had two shots of Fireball Whiskey.

You should grab a couple more and share them with Dad if he drinks at all.

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