Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 7,484 total)

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Ed Wagner (9/5/2014)

    And finally, even through I worked with Oracle for a number of years, a NULL and an empty string are fundamentally different and should never be equal.

    Nor unequal,...

    September 5, 2014 at 3:48 pm

    #1743632

  • RE: Today's Random Word!

    Ed Wagner (9/5/2014)

    Sean Lange (9/5/2014)

    Capsize

    Expensive

    Dear

    September 5, 2014 at 3:45 pm

    #1743630

  • RE: Titles Matter – Part 2

    Gary Varga (9/5/2014)

    DavidL (9/5/2014)

    GilaMonster (9/5/2014)

    Personally.... My father's an engineer (mechanical). I know what goes into studying to be an accredited engineer. I will never use the title Engineer for myself...

    September 5, 2014 at 2:01 pm

    #1743617

  • RE: What will this query return?

    Hugo Kornelis (9/5/2014)

    TomThomson (9/4/2014)

    I have written quite a few parsers, and handling what I've described is not at all hard

    That comment was not directed at you or your proposal. 🙂

    One...

    September 5, 2014 at 1:44 pm

    #1743616

  • RE: Are the posted questions getting worse?

    GilaMonster (9/5/2014)

    Grant Fritchey (9/4/2014)

    You never know. I get stumped all the time. That's why Gail's here.

    Wha?

    Well, at least I have a purpose in life...

    Well, a purpose in SQLserverCentral forums anyway....

    September 5, 2014 at 1:32 pm

    #1743614

  • RE: Are the posted questions getting worse?

    cphite (9/5/2014)

    jcrawf02 (9/4/2014)

    Ed Wagner (9/4/2014)

    Koen Verbeeck (9/4/2014)

    andrew gothard (9/4/2014)

    Gazareth (9/3/2014)

    I've just been told: "We don't recommend running SQL commands against the database"

    Right. May as well go home then!

    You know Chris...

    September 5, 2014 at 1:30 pm

    #1743613

  • RE: How bad this in terms of performance; udf in WHERE

    CELKO (9/4/2014)

    The highlighted (bolded) pattern for validation will allow for INVALID MONTHS. Since when do we have a 13th, 14th, 15th, 16th, 17th, 18th, or 19th month in ANY...

    September 5, 2014 at 11:24 am

    #1743586

  • RE: How bad this in terms of performance; udf in WHERE

    Lynn Pettis (9/4/2014)

    CELKO (9/4/2014)

    The highlighted (bolded) pattern for validation will allow for INVALID MONTHS. Since when do we have a 13th, 14th, 15th, 16th, 17th, 18th, or 19th month...

    September 5, 2014 at 11:04 am

    #1743580

  • RE: How bad this in terms of performance; udf in WHERE

    CELKO (9/4/2014)

    I like the MySQL convention of using double zeroes for months and years, That is 'yyyy-mm-00' for a month within a year and 'yyyy-00-00' for the whole year.

    Yes, I've...

    September 5, 2014 at 10:40 am

    #1743574

  • RE: M2M logins IP based access restriction

    That's something I would expect to do in a firewall (either a software one on the machine restricting access, or a hardware one between the machine and the outside world)....

    September 5, 2014 at 10:06 am

    #1743565

  • RE: Shrink tempdb

    Did you restart the instance after runing the alter database statement? If you did, tempdb should now start with the file size that statement specified.

    Also, it may be...

    September 5, 2014 at 9:52 am

    #1743560

  • RE: Adding a number to a string to create series

    ChrisM@Work (9/5/2014)

    Eirikur Eiriksson (9/5/2014)

    Chances are that this serialization is being used outside the scope of the database, ie. enumeration of report or invoice items, who knows?

    😎

    Nobody, Mr Viking - but...

    September 5, 2014 at 9:35 am

    #1743554

  • RE: Titles Matter – Part 2

    GilaMonster (9/5/2014)

    Personally.... My father's an engineer (mechanical). I know what goes into studying to be an accredited engineer. I will never use the title Engineer for myself (I'm not one)

    When,...

    September 5, 2014 at 9:17 am

    #1743546

  • RE: Data from one Table to Two Columns

    ok, it can be done by numbering the logging events in order, then splitting into logins and logouts, and then doing a full outer join on the tow parts with...

    September 5, 2014 at 7:07 am

    #1743507

  • RE: Today's Random Word!

    Ed Wagner (9/5/2014)

    BWFC (9/5/2014)

    TomThomson (9/4/2014)

    Ed Wagner (9/4/2014)

    djj (9/4/2014)

    Ed Wagner (9/4/2014)

    Revenant (9/4/2014)

    SQLRNNR (9/4/2014)

    silver

    spoon

    Feed

    Qats

    Granola

    Museli

    Sawdust 🙂

    Project

    Projectile

    September 5, 2014 at 6:02 am

    #1743485

Viewing 15 posts - 2,236 through 2,250 (of 7,484 total)