Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 11,678 total)

  • RE: Tribal Awards 2014 Winners

    Congrats to all the winners!

  • RE: COUNT NULLs

    Tony.l (1/20/2015)


    What does database indicate about nulls being allowed in this table if it is not specified as part of the create table - the insert would fail thus not...

  • RE: COUNT NULLs

    Nice question. Pretty straightforward after the discussion of the previous COUNT question 😉

  • RE: Running SSIS 2014 and 2012 Concurrently - Some general questions

    JoshDBGuy (1/20/2015)


    Phil Parkin (1/20/2015)


    JoshDBGuy (1/20/2015)


    Koen Verbeeck (1/20/2015)


    JoshDBGuy (1/20/2015)


    That's going to be a nightmare, I'd prefer to not do that.

    I'm not sure why a SQL Server instance would be a nightmare.

    It's...

  • RE: Running SSIS 2014 and 2012 Concurrently - Some general questions

    JoshDBGuy (1/20/2015)


    That's going to be a nightmare, I'd prefer to not do that.

    I'm not sure why a SQL Server instance would be a nightmare.

  • RE: Running SSIS 2014 and 2012 Concurrently - Some general questions

    JoshDBGuy (1/20/2015)


    Phil Parkin (1/20/2015)


    JoshDBGuy (1/20/2015)


    I inherited an environment with a SQL Server 2014 environment. It looks like they installed 2014 SSIS concurrently with 2012, leaving both services on the box....

  • RE: ID or Id

    Sean Lange (1/20/2015)


    Eric M Russell (1/20/2015)


    Sean Lange (1/20/2015)


    Eric M Russell (1/20/2015)


    I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as...

  • RE: The Identity Limit

    OCTom (1/20/2015)


    An identity has no limit itself. It depends on the datatype used for the field.

    Tom

    Yes, but there are a limited number of possible data types and they all have...

  • RE: ID or Id

    Phil Parkin (1/20/2015)


    According to Merriam-Webster: it should be ID.

    Id - or in a sentence id - refers to part of the psyche defined by Freud.

    For a bit of balance,...

  • RE: ID or Id

    Phil Parkin (1/20/2015)


    But as the ID/Id bit is abbreviating only a single word, the rational side of me chooses Id.

    Also, following your logic, it should be Tv instead of...

  • RE: ID or Id

    Eugene Elutin (1/20/2015)


    Both are good to me, plus:

    product_id

    ... as per column name convention in system tables ...

    Right, as if system tables are consistent 😀

    (and why should we trust Microsoft...

  • RE: ID or Id

    According to Merriam-Webster: it should be ID.

    Id - or in a sentence id - refers to part of the psyche defined by Freud.

  • RE: ID or Id

    GilaMonster (1/20/2015)


    I use ID, everyone else in my company uses Id.

    So, you switch places with Phil and everything is settled then. 🙂

  • RE: ID or Id

    ID (or Id or I.D.) is not necessarily an abbreviation of the word "identity". It can also be an acronym for "identity document", such as drivers ID or national ID...

  • RE: How the datediff determinines the difference between two dates?

    Jeff Moden (1/19/2015)


    Be advised that the "wk" DATEPART can change depending on language settings and DATEFIRST settings. It's not considered to be a good thing to use.

    +1

    I would calculate...

Viewing 15 posts - 1,111 through 1,125 (of 11,678 total)