Forum Replies Created

Viewing 15 posts - 16,351 through 16,365 (of 59,101 total)

  • RE: What's the best practice to auto import files from SFTP

    Heh... some clients are worth losing. 😉

    The title of your post did ask "What's the best practice to auto import files" and what I wrote in my previous post is...

    --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 12, 2016 at 8:47 am

    #1912062

  • RE: TSQL Formatting tool?

    Eirikur Eiriksson (11/12/2016)

    I've also found that I can, indeed, frequently tell the difference between someone that used a formatting tool and someone that did not even when both are formatted...

    --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 12, 2016 at 8:33 am

    #1912061

  • RE: Understanding from .. from

    Edvard Korsbæk (11/12/2016)

    Hi All!

    I got some code from another, where i have som understanding problems.

    Its pretty long, but the start is:

    DELETE FROM dbo.DutyRosterShift FROM dbo.DutyRosterShift B

    WHERE

    B.DutyRosterId...

    --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 12, 2016 at 7:57 am

    #1912059

  • RE: What's the best practice to auto import files from SFTP

    halifaxdal (11/11/2016)

    This is really a challenging to me: I am assigned folders (yes, plural, more than one folder) on SFTP server, each folder correspondent to one client. Each folder will...

    --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 12, 2016 at 6:46 am

    #1912056

  • RE: Inline table-valued function to list numbers

    p.s. First, thank you for wanting "hints" instead of a "solution". It absolutely demonstrates that you have the right stuff for database programming.

    Second, because of your interest in...

    --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 11, 2016 at 8:12 pm

    #1912021

  • RE: Inline table-valued function to list numbers

    TheTrojan (11/11/2016)

    Hi everyone,

    I'm a newbie and recently I've come across an excercise quite complex (for me). In short, these are the requirements:

    A - an inline table-valued function with 1 parameter...

    --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 11, 2016 at 7:51 pm

    #1912020

  • RE: TSQL Formatting tool?

    Eric M Russell (11/11/2016)

    Jeff Moden (11/11/2016)

    Eric Mamet (11/10/2016)

    Can someone recommend a (free?) tool to format TSQL Code.

    Ideally, it should be something working in both SSMS and Visual Studio (SSDT)...

    --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 11, 2016 at 7:17 pm

    #1912019

  • RE: TSQL Formatting tool?

    Eric Mamet (11/10/2016)

    Can someone recommend a (free?) tool to format TSQL Code.

    Ideally, it should be something working in both SSMS and Visual Studio (SSDT) as we use both 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 11, 2016 at 12:57 pm

    #1911994

  • RE: Inserting records failing everyday

    EasyBoy (11/8/2016)

    We have one schedule job which dropping and inserting records into table on daily basis. But this job is failing due to "Could not allocate space for 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 11, 2016 at 12:50 pm

    #1911991

  • RE: Substring a value after a period

    hoseam (11/11/2016)

    I get string values as input, e.g 'Documentation.Account', whatever value I get I want to extract it to get anything after a period(.) e.g'Account' I was thinking of using...

    --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 11, 2016 at 12:44 pm

    #1911988

  • RE: Deployment Solutions that include Data?

    If RedGate Data Compare is used against relatively small amount of reference data, then it works just fine. The problem is that they generate data scripts that are RBAR...

    --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 11, 2016 at 12:33 pm

    #1911986

  • RE: Back-to-Back Version of SQL Server

    Saurabh.D (11/10/2016)

    Hi,

    Not Sure, right place to ask.

    I am very new to SQL Server.

    Why Microsoft release Back-to-Back version of SQL Server...

    --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 11, 2016 at 12:27 pm

    #1911985

  • RE: Go Code

    I don't believe that everyone can be taught to code simply because it's not something that some people actually have an interest in doing. There are also those 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 11, 2016 at 12:20 pm

    #1911981

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/10/2016)

    Jeff Moden (11/9/2016)

    Lynn Pettis (11/9/2016)

    Jeff, I actually excepted you to have some interesting comments about the code I emailed you, or didn't you get it?

    Ah. sorry. I...

    --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 10, 2016 at 12:25 pm

    #1911758

  • RE: How to use a CSV as parameter in a query

    Eirikur Eiriksson (11/10/2016)

    Further on the fixed width method, here is an example, 100 x more efficient than XML and roughly 4-8 x more efficient than DelimitedSplit8K.

    😎

    I have proven many times...

    --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 10, 2016 at 5:50 am

    #1911626

Viewing 15 posts - 16,351 through 16,365 (of 59,101 total)