Forum Replies Created

Viewing 15 posts - 46 through 60 (of 194 total)

  • RE: Is Division by Zero NULL?

    Steve Jones - SSC Editor (9/8/2016)


    I had a report about this thread. I think it's a valid discussion, and as long as everyone remains respectful, that's fine.

    There have been a...

  • RE: getutcdate during daylight savings time

    Marcia Q (9/1/2010)


    The way I interpret it: Since it's derived from our local time (which will bump by an hour on November 7), the UTC will also bump...

  • RE: Time Off

    S Hodkinson (9/2/2016)


    Ah the classic line....'Enter Bluebottle wearing Arab headdress and cardboard knees'. Or the Ying Tong Song.

    And while we're on it......Navy Lark or Round the Horne anyone?

    No actually...

  • RE: Data Quality - Addressing non-stated requirements

    Definitely

    Perform basic validation of datatype and format in the UI or input routines, Identify any exceptions and handle appropriately. Fail the validation immediately if these fail so we don't incur...

  • RE: Data Quality - Addressing non-stated requirements

    Frequently you do know what you don't know.

    Here there are 4 categories of knowledge

    Known knowns

    Unknown knowns

    Known unknowns

    Unknown Unknowns

    Most people will understand the first and last of these.

    The second is...

  • RE: Data Quality - Addressing non-stated requirements

    RobertMcClean (7/28/2016)


    Good article, and good point about the difficulty in getting non-technical people to realize how much they can contribute. I recall that an Auditor once complimented us on the...

  • RE: Fuzzy Processing

    something along the lines of the work Google undertook to get house numbers into GoogleMaps

    https://www.technologyreview.com/s/523326/how-google-cracked-house-number-identification-in-street-view/

  • RE: Fuzzy Processing

    dld (7/7/2016)


    Watch the movie "Brazil" for an example of fuzzy logic and mistaken identity. It's a hoot.

    Tuttle, Tuttle

    One of my favourite films 🙂

  • RE: Fuzzy Processing

    you forgot Mc not that you see it used often nowadays.

    There have been enough cases of incorrect identity that you would hope that any warrant to arrest Joanne Bloggs instead...

  • RE: Fuzzy Processing

    Peoples' names would be another, especially if it needs to handle misspellings, contractions and variants. There is also the issue as to whether middlenames are used.

  • RE: Byte Me: DeleteDeleteDelete

    I wonder if it works for home off<tap tap tap> ........

  • RE: Run through all user tables, add an user

    saintor1 (6/20/2016)


    IT provided me that user, attached to all users login (authenticated windows ). I know very little about active directory and such.

    That sounds like you...

  • RE: Using reserved words as column names

    Sioban Krzywicki (4/28/2016)


    I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all...

  • RE: Binary Compare

    patrickmcginnis59 10839 (5/18/2016)


    Perry Whittle (5/17/2016)


    Bob JH Cullen (5/17/2016)


    which in any integer expression are irrelevant, surely?

    This is not an integer expression.

    The code first checks the binary values for @a and @b-2,...

  • RE: Binary Compare

    Bob,

    It comes down to how the OS stores data

    0x01 is an 8 bit hex number - binary 00000001

    0x0001 is a 16 bit hex number 0000000000000001

    if you compare these as 16...

Viewing 15 posts - 46 through 60 (of 194 total)