Forum Replies Created

Viewing 15 posts - 13,501 through 13,515 (of 59,095 total)

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

December 6, 2017 at 5:55 pm

#1971084

  • RE: Bulk insert into table from csv

    I thought you solved it...

    Hmm it is very strange - now i file was uploaded with success!

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

    December 6, 2017 at 7:12 am

    #1970923

  • RE: Can Data Save the World?

    Here's another couple of problems that people from "all walks of data involvement" make... out of context assumption and just being in too much of a hurry.  Take a look at...

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

    December 6, 2017 at 6:57 am

    #1970914

  • RE: Can Data Save the World?

    Heh... Granny use to have a great saying that applies to data... "Figures can lie... and liars figure".  A story can be warped to make anything it wants out of...

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

    December 5, 2017 at 9:57 pm

    #1970843

  • RE: Find Differences Between Two Tables

    BTW... the formula for the number of Cartesian Products required for "N" columns of "any two columns match" is ((N-1)^2 + (N-1))/2.  That means that just 10 columns would require 45...

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

    December 5, 2017 at 9:29 pm

    #1970840

  • RE: Find Differences Between Two Tables

    There are two major problems with all of this...

    The first problem is that, although you tried, you didn't try to run your the test data code you posted...

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

    December 5, 2017 at 9:19 pm

    #1970839

  • RE: Job getting stuck in UAT but runs fine in Prod

    coolchaitu - Monday, December 4, 2017 10:03 AM

  • Good Morning Experts
  • One  of our jobs is getting stuck everytime it is triggered...

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

    December 5, 2017 at 8:14 pm

    #1970830

  • RE: Job getting stuck in UAT but runs fine in Prod

    HappyGeek - Monday, December 4, 2017 11:10 AM

    I would be more worried about why it has not passed in UAT and yet 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)

    December 5, 2017 at 8:07 pm

    #1970829

  • RE: A simple example which, after 15 years of relational design work, still breaks my brain - phone numbers

    So what are the "ex GST amount" and a "GST amount" columns that you speak of?  In particular, what is the difference due to the "ex" in the first column...

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

    December 5, 2017 at 8:05 pm

    #1970828

  • RE: Slow query - client or server issue

    leehbi - Tuesday, December 5, 2017 3:51 AM

    I denormalised some of the underlying tables - this resulted in a much simpler plan. ...

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

    December 5, 2017 at 5:35 pm

    #1970821

  • RE: Transaction log issue

    WhiteLotus - Monday, December 4, 2017 8:56 PM

    HI All

    I have a repeat incident in my database server
    Transaction log is getting full...

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

    December 5, 2017 at 5:14 pm

    #1970820

  • RE: extract string between underscore

    Joe Torre - Tuesday, December 5, 2017 2:07 PM


    DECLARE @t table(Id int IDENTITY,textval varchar(255));
    INSERT @t ( textval ) VALUES
        ( 'BA6FC89_78345_CET_12345_16890_87651010' )
     ...

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

    December 5, 2017 at 5:11 pm

    #1970819

  • RE: Are the posted questions getting worse?

    Thom A - Tuesday, December 5, 2017 12:54 PM

    Chris Harshman - Tuesday, December 5, 2017 12:28 PM

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

    December 5, 2017 at 4:56 pm

    #1970818

    • Viewing 15 posts - 13,501 through 13,515 (of 59,095 total)