Forum Replies Created

Viewing 15 posts - 766 through 780 (of 1,415 total)

  • RE: Processing strings.

    Jeff Moden (4/4/2016)


    You're correct. I mostly can't tell the difference between C# and VB. I was going on what Sachin stated near his code...

    Between I am not a...

  • RE: Processing strings.

    Jeff Moden (4/4/2016)


    patrickmcginnis59 10839 (4/4/2016)


    Jeff Moden (4/4/2016)


    patrickmcginnis59 10839 (4/4/2016)


    But whatever floats your boat, if you can't see two inches beyond your TSQL experience, the least you could do is admit...

  • RE: Processing strings.

    Jeff Moden (4/4/2016)


    patrickmcginnis59 10839 (4/4/2016)


    But whatever floats your boat, if you can't see two inches beyond your TSQL experience, the least you could do is admit that separate language linking...

  • RE: Processing strings.

    Jeff Moden (4/2/2016)


    Also, instead of using C# to call Visual Basic, stop the tower of Babel and just make the CLR using Visual Basic.

    Heck I've been able to use multiple...

  • RE: Do Less

    roger.plowman (3/24/2016)


    Preaching to the choir here. 😀

    My first programming was done on a 1962 vintage IBM 1130. In Fortran. On punch cards. (laughing)

    Yeah, you learn minimalism really fast when you...

  • RE: Index reorganization

    ramana3327 (3/21/2016)


    We are using standard edition of SQL Server.

    We are doing index rebuild on weekends but I am trying to change index maintenance job to reorg daily based on...

  • RE: Database Design Follies: NULL vs. NOT NULL

    removed

  • RE: Database Design Follies: NULL vs. NOT NULL

    Zidar (3/3/2016)


    When you come back tomorrow, I'm wondering why

    NullColumn = 'MISSING'

    is not what you call a token?

    I believe that Old Hand provided adequate answer in his post 1766165. NullColumn...

  • RE: Database Design Follies: NULL vs. NOT NULL

    Zidar (3/2/2016)


    Grasshopper, if the "null" columns are stored in separate tables (6NF?), then a join (left) to build the original table would return nulls for the missing value. I see...

  • RE: Database Design Follies: NULL vs. NOT NULL

    I hope it is clear, mathematically speaking, NULLs and tokens do not represent domain values for attributes. Thus, they must not be used in relational design.

    Then how do we represent...

  • RE: Database Design Follies: NULL vs. NOT NULL

    j-1064772 (2/29/2016)


    "But for the sanity of folks who use database software, DON'T HAVE YOUR RDBMS VENDOR HARD WIRE MEANINGS INTO NULLS."

    Speaking from bitter experience perhaps ?

    heh vendors *rolls eyes*

  • RE: Database Design Follies: NULL vs. NOT NULL

    roger.plowman (2/29/2016)


    I still don't see why relational tables can't have records for TBD, N/A, and UNK.

    If you need to know why a value is missing, you're going to have to...

  • RE: IDEs sweet but beguiling

    Jeff Moden (2/29/2016)


    patrickmcginnis59 10839 (2/29/2016)


    Jeff Moden (2/27/2016)


    This is a really good article, Phil. It actually echoes what Bill Gates predicted back in the '80s when he said that, soon,...

  • RE: IDEs sweet but beguiling

    Jeff Moden (2/27/2016)


    This is a really good article, Phil. It actually echoes what Bill Gates predicted back in the '80s when he said that, soon, there would be no...

  • RE: Database Design Follies: NULL vs. NOT NULL

    ScottPletcher (5/21/2015)


    JediSQL (10/31/2014)

    In most conditional statements, like WHERE clauses and IF statements, the conditional expression will return TRUE if and only if SQL Server considers the assertion provably true. ...

Viewing 15 posts - 766 through 780 (of 1,415 total)