Forum Replies Created

Viewing 15 posts - 28,036 through 28,050 (of 59,101 total)

  • RE: Splitting Strings Based on Patterns

    peter-757102 (11/29/2012)

    I haven't read the article properly and just scanned it to see what it is about and if it is interesting.

    But one thing I noticed quickly was a quote...

    --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)

    November 29, 2012 at 4:27 pm

    #1564092

  • RE: Splitting Strings Based on Patterns

    Peter H (11/29/2012)

    My version of SQL (2005) does not seem to handle the "VALUES" in

    SELECT TOP(DATALENGTH(@List))

    n = ROW_NUMBER() OVER(ORDER BY (SELECT NULL))

    FROM

    (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0))...

    --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)

    November 29, 2012 at 4:21 pm

    #1564090

  • RE: Splitting Strings Based on Patterns

    Irozenberg 1347 (11/29/2012)

    Why we have to be inventive and create such acrobatic solution in a first place? Just to compensate for bad design and implementation decisions.

    In a word, YES!...

    --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)

    November 29, 2012 at 4:17 pm

    #1564087

  • RE: Exercises in t-SQL

    wolfkillj (11/29/2012)

    The real problem with the fizzbuzz puzzle for evaluating a programmer's ability is that it is only a puzzle. Once someone has seen it solved, the puzzle presents 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)

    November 29, 2012 at 3:20 pm

    #1564074

  • RE: How to recover a dropped table

    Grant Fritchey (11/28/2012)

    There is no way. Sorry.

    If it's a dev environment, you may not want to set up extensive backup routines (for many obvious reasons) which is yet another reason...

    --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)

    November 28, 2012 at 7:19 pm

    #1563537

  • RE: Exercises in t-SQL

    wolfkillj (11/28/2012)

    Jeff Moden (11/27/2012)

    CELKO (11/27/2012)

    Create a million row FizzBuzz table. FizzBuzz isn't a comment. It's the name of a very common problem based on a child's game,...

    --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)

    November 28, 2012 at 5:33 pm

    #1563523

  • RE: LUN

    GilaMonster (11/28/2012)

    weberharter (11/28/2012)

    ... but if the terms are used here, why not explain it? 😉

    Because we assume that people know the basic terminology or, if they don't, will go and...

    --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)

    November 28, 2012 at 4:53 pm

    #1563518

  • RE: OPENQUERY error: An unexpected NULL value was returned

    Jennifer Levy (11/28/2012)

    I had to change the numeric columns on the SQL Server side to allow NULLs, but it ran just fine once I'd done that.

    No kidding? Thanks for...

    --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)

    November 28, 2012 at 4:49 pm

    #1563517

  • RE: create index on nvarchar value

    I'll also add that you pretty much blow yourself out of the water when using any blob-type including things like NVARCHAR(MAX) and XML when it comes to being able 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)

    November 28, 2012 at 4:44 pm

    #1563515

  • RE: How to know which column updated

    suresh0534 (11/28/2012)

    Thanks for your reply.

    But i want when the user updating any fileds in the table , only those fileds i need to insert into another table.

    So i can know...

    --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)

    November 28, 2012 at 4:40 pm

    #1563513

  • RE: Regulators, Mount Up

    David.Poole (11/28/2012)

    Its amazing what happens if you wave the possiblity of nuking old dead systems in front of a DBA. Their wrinkles vanish, an unfamiliar expression (happy smile) crosses...

    --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)

    November 28, 2012 at 4:37 pm

    #1563511

  • RE: Regulators, Mount Up

    Michael Valentine Jones (11/28/2012)

    TravisDBA (11/28/2012)

    It's not just unencrypted data that auditors ding you on nowadays. Wearing many hats at once and doing things outside your job description can definitely get...

    --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)

    November 28, 2012 at 4:34 pm

    #1563509

  • RE: Regulators, Mount Up

    David.Poole (11/28/2012)

    Regulation is a cloud that can have a bright silver lining.

    Lets suppose that you have old systems ridden with tech debt and propped up by manual processes.

    Those powers that...

    --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)

    November 28, 2012 at 4:31 pm

    #1563508

  • RE: Transpose Rows to Columns with first column values as column names from the table??

    lynn.huff (11/27/2012)

    That all applies to aggregating, which doesn't apply to my problem.

    Actually, it does. Use MAX instead of SUM to transpose character based items.

    --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)

    November 28, 2012 at 2:51 pm

    #1563465

  • RE: Baselining Database Code

    Why not just right click on the database, select "tasks", "generate scripts", and select box to create 1 file per object?

    --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)

    November 28, 2012 at 2:46 pm

    #1563463

Viewing 15 posts - 28,036 through 28,050 (of 59,101 total)