Forum Replies Created

Viewing 15 posts - 26,326 through 26,340 (of 59,099 total)

  • RE: Less QA?

    sue.james (7/31/2013)

    Let's all back up a minute and think about the true source of the problem .... poorly written specifications (if the developer even got one at all). When...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 9:12 pm

    #1637640

  • RE: N' annotation

    grecci1077 (7/31/2013)

    I am still trying to make sense of the whole n' when selecting text or varchar values... Is that so necessary? Can someone give me an example?

    To summarize what...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 9:07 pm

    #1637639

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/31/2013)

    Jeff Moden (7/31/2013)

    Steve Jones - SSC Editor (7/31/2013)

    That being said, the icons shouldn't have been rolled out without site design changes.

    Heh... I guess there's no...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 8:58 pm

    #1637637

  • RE: Are the posted questions getting worse?

    Jack Corbett (7/31/2013)

    Jeff Moden (7/31/2013)

    Jack Corbett (7/31/2013)

    I actually like the new icons. I think they are easier to read and more clearly show what they...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 8:53 pm

    #1637636

  • RE: A New Look

    Steve Jones - SSC Editor (7/31/2013)

    Not true. Different people, different skills sets here. If the people changing the look could code, I'd have a lot of stuff fixed.

    Ah... I understand...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 2:56 pm

    #1637579

  • RE: Are the posted questions getting worse?

    Jack Corbett (7/31/2013)

    I actually like the new icons. I think they are easier to read and more clearly show what they represent. There are only 2...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 2:50 pm

    #1637577

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/31/2013)

    That being said, the icons shouldn't have been rolled out without site design changes.

    Heh... I guess there's no use in responding to anymore "New Look"...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 2:46 pm

    #1637574

  • RE: A New Look

    Steve Jones - SSC Editor (7/31/2013)

    Jeff Moden (7/29/2013)

    I just took a look at the home page for the first time this morning. Why in the hell do people think...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 31, 2013 at 10:43 am

    #1637482

  • RE: Shrink database file with EMPTYFILE option

    GilaMonster (7/30/2013)

    Jeff Moden (7/30/2013)

    GilaMonster (7/30/2013)

    There is no requirement that a DB be in single user mode or quiesced to do a shrink file.

    That's true but it makes it a heck...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 30, 2013 at 6:08 pm

    #1637178

  • RE: Need a help in MCSA SQL Server exam 2012 70-461, 462, 463

    I don't know if any are actually available but Amazon sometimes has used books on sale for a fraction of the cost of a new book.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 30, 2013 at 6:04 pm

    #1637176

  • RE: Universal CSV-Importer

    Erland Sommarskog (7/30/2013)

    Jeff Moden (7/30/2013)

    Use Bulk Insert to read just the first line of a file into a single column temp table. Split that column on the delimiter to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 30, 2013 at 5:56 pm

    #1637174

  • RE: Shrink database file with EMPTYFILE option

    GilaMonster (7/30/2013)

    There is no requirement that a DB be in single user mode or quiesced to do a shrink file.

    That's true but it makes it a heck of a lot...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 30, 2013 at 3:58 pm

    #1637161

  • RE: Universal CSV-Importer

    info 58414 (7/30/2013)

    Is there a way, to import csv Files with different count of fields (all nvarchar (max)) with one Stored-Procedure in one fix table (with Import-ID) , without having...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 30, 2013 at 3:49 pm

    #1637156

  • RE: Need Help TSQL Code.

    geoff5 (7/30/2013)

    I think this is a slightly shorter solution.

    LastName = reverse(left(reverse(FullName), charindex(' ', reverse(FullName)) - 1))

    How is that shorter and why do you believe that 3 REVERSEs are...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 30, 2013 at 3:41 pm

    #1637149

  • RE: Are the posted questions getting worse?

    WayneS (7/29/2013)

    Just curious - how many like that new tile look on the home page?

    FWIW: I prefer the older images over these tiles.

    I hate it. We went from some...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 30, 2013 at 3:34 pm

    #1637144

Viewing 15 posts - 26,326 through 26,340 (of 59,099 total)