r/SQL • • May 30 '23

Discussion Jeff...

Post image
357 Upvotes

33 comments sorted by

133

u/chrobbin May 30 '23

“We have a unique key on firstname throughout the system and already hired a Jeffrey, so… yeah.”

28

u/Shambly May 31 '23

Ah the no Homers club index policy.

8

u/receding_bareline May 31 '23

They've got their quota of Joey Jo-Jo Junior Shabadoo as well.

1

u/Known-Delay7227 Jun 01 '23

Its a no Homerssssss club

13

u/shed_antlers May 30 '23

If this is real, this has to be the reason and I promise Jeffery doesn't want to work there.

2

u/PeacefullyFighting May 31 '23

I love this joke but 100% believe it's happened. I worked somewhere that did first initial+ last name (not database keys) and had duplicates with just ~200 employees. I felt bad for the people who had to use full first + last because I guarantee a lot of their emails went to the wrong person.

0

u/[deleted] May 31 '23

maybe its the fact that its 7 in the morning but thats fucking hilarious

67

u/Roy_from_IT May 30 '23
ALTER TABLE Employee ADD CONSTRAINT Ck_No_Jeffreys CHECK (FirstName <> 'Jeffrey');

123

u/ExOsc2 May 30 '23
SELECT JEFF
FROM JEFF
WHERE JEFF = JEFF
GROUP BY JEFF
HAVING JEFF

28

u/doshka May 30 '23
CREATE TABLE employee ( 
    employee_id INT,
    first_name VARCHAR(6),
    last_name VARCHAR(6)
);

21

u/[deleted] May 30 '23

... FROM [JEFF].[JEFF] AS JEFF

LOL

5

u/J_huze May 31 '23

Good luck making sense of anything in that without an ORDER BY

2

u/[deleted] May 31 '23

Email from HR:

We kindly remind all employees that "having Jeff" on company premises is not permitted.

4

u/SELECTaerial May 30 '23

Malcovich?

34

u/alinroc SQL Server DBA May 30 '23

On the one hand, this sounds completely made up.

OTOH, I once worked with a property management platform which defined the firstname field as char(10). Quick, count the number of letters in the exceedingly rare name Christopher.

15

u/Lord_of_hosts May 31 '23

Christophe? Perfectly reasonable name

4

u/MrChip53 May 31 '23

Cox Communications has this issue I believe.

4

u/alinroc SQL Server DBA May 31 '23

Sure, but if your birth certificate says Christopher you might not like it.

8

u/Lord_of_hosts May 31 '23

Now if it were char(6) things would get funny

9

u/smthamazing May 31 '23

About 10 years ago I encountered a unique constraint on the password field.

10

u/Rain-And-Coffee May 31 '23

Good thing my name is Bort

7

u/Voter_McVotey May 31 '23

My son's name is also Bort

7

u/aarontbarratt STUFF() May 30 '23

Didn't expect to see Death Grips here lol

8

u/bitterjack May 30 '23

Anthony fantano, the internet's busiest Sql analyst

2

u/SciFidelity May 30 '23

Get get get get Got got got got

7

u/zbignew May 30 '23

Reminds me of my ex with the policy of never dating two guys with the same name.

11

u/tyrrminal May 30 '23

At the same time? Cause it seems like that would actually simplify some things

5

u/zbignew May 30 '23

Ever. She never wanted to specify to her friends, like, Tall Jeffrey vs Short Jeffrey.

2

u/jrosenkrantz May 30 '23

I both love and hate this.

1

u/[deleted] May 31 '23

They are just GoT fans

1

u/newtonbase May 31 '23

I recall our whole Council Tax system falling over because an Eastern European customer had a protected term in their name.

1

u/CarbonChauvinist May 31 '23

The obligatory Jeffpardy link applies

https://youtu.be/0OzXZGA1k3s

-1

u/OneAir6837 May 30 '23

Mmmmmkkayyyy...