Root Access

« first day (2477 days earlier) ← previous day next day → last day (2543 days later) »

Ben N

11:00 PM

Hi!

Bob

hmm. they seem to be laying conduit down the road

DavidPostill

@Bob Knowing your luck they will stop before they get to your house ;p

Burgi

its for gas

DavidPostill

@Burgi lol

Bob

@DavidPostill not planned till late next year, so probably something else

Burgi

11:11 PM

do you think smallint will be enough to cover values for NumEmployees?

Ben N

Maybe now, but that could change in the future

DavidPostill

@Burgi If smallint is 65,535 then that's a lot of employees...

Burgi

@DavidPostill its signed

Ben N

If it's signed, that's "only" 32,767

Burgi

i think it'll be fine

DavidPostill

11:17 PM

@BenN @Burgi Why should it be signed? You can't have a negative employee number

Burgi

not sure you can specify if its signed or not

Ben N

If this is MySQL, this document seems to imply you can, but doesn't say how

Burgi

its SQL Server

meh it'll be fine

Ben N

Does signed smallint work?

Gypsy Spellweaver

32,768, or 65,535 may not be that many employees if you run the program very long, since every employee will need a new number, not a recycled number from last year, or five years ago.

Burgi

11:25 PM

its a total number of employees, not a unique employee identifer

DavidPostill

@BenN smallint unsigned apparently

Ben N

Oh right, we're going for unsigned

Burgi

i've set the TravelRange to smallint already

if they can service anyone within range of 32000 miles they are astronauts

its a bit of a fudge tbh

Gypsy Spellweaver

It seems that SQL Server may not support unsigned integers, and probably won't. See connect.microsoft.com/SQLServer/feedback/details/515502/…

Ben N

Ah, nice find

Gypsy Spellweaver

11:31 PM

Q: Why aren't unsigned integer types available in the top database platforms?

Databases are usually very customizable with varying data types and custom lengths. It surprises me, as I try to look for the syntax to use unsigned int types that they are not available from neither PostgreSQL and MS SQL Server. MySQL and Oracle seem to. This seems like a glaring omission on t...