Forum Replies Created

Viewing 15 posts - 18,511 through 18,525 (of 59,072 total)

  • RE: Striped backups and cursor

    Richard Moore-400646 (1/25/2016)

    Hey Jeff,

    Thanks for your reply. Funny you should ask that as I'm in the process of testing and verifying that information. Initial tests show marginal differences...

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

    January 25, 2016 at 6:45 pm

    #1854350

  • RE: Database restore automate

    Sree Divya (1/25/2016)

    hi,

    in my shared location db backup is .lbak

    Like I said, use xp_DirTree. Here's an example...

    EXEC xp_DirTree 'C:\',1,1

    Replace the "C:\" with either the drive and path 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)

    January 25, 2016 at 6:42 pm

    #1854349

  • RE: Convert a Date

    Eirikur Eiriksson (1/25/2016)

    Jeff Moden (1/25/2016)

    Yes. Not because of the low quantity but because someone else in search of code may find it and use it on something larger or...

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

    January 25, 2016 at 4:50 pm

    #1854336

  • RE: Striped backups and cursor

    Richard Moore-400646 (1/25/2016)

    Thanks very much for the replies. I've corrected the counter issue and will look the versions that Luis provided.

    Shifting gears a bit, I have two questions...

    1. ...

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

    January 25, 2016 at 4:47 pm

    #1854334

  • RE: Crafting Your Resume

    Heh... according to the interviews I've been conducting for the last several years, people have spent way too much time crafting their resume instead of learning their craft. :sick:

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

    January 25, 2016 at 4:40 pm

    #1854332

  • RE: Hard Data v Gut Feel

    I guess "It Depends" on what you call a "gut feel". I was recently asked to provide hard evidence that a particular stored procedure was the source of a...

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

    January 25, 2016 at 4:34 pm

    #1854330

  • RE: Calendar Table Function

    dietztm (1/25/2016)

    We use a date dimension which has any date we'd want to get other info from and join on the date. If I wanted to do this in memory...

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

    January 25, 2016 at 3:50 pm

    #1854325

  • RE: Convert a Date

    Luis Cazares (1/25/2016)

    That's why we should keep dates as dates until final output. To exchange data from one system to another, if a string representation is absolutely needed (flat files),...

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

    January 25, 2016 at 11:26 am

    #1854249

  • RE: Convert a Date

    On that same note, I've repaired the "big", high ROI performance problems associated with the front end for our company and the users still complain of performance problems. The...

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

    January 25, 2016 at 9:42 am

    #1854215

  • RE: Convert a Date

    spaghettidba (1/25/2016)

    Eirikur Eiriksson (1/25/2016)

    spaghettidba (1/25/2016)

    Eirikur Eiriksson (1/25/2016)

    spaghettidba (1/25/2016)

    SQL Server 2012 supports the FORMAT function:

    select format(GETDATE(), 'dd-MMM-YYYY')

    Gianluca, don't use the format function, it has terrible performance.

    😎

    It is a CLR function, so...

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

    January 25, 2016 at 9:30 am

    #1854210

  • RE: Importing Error - Text was truncated...

    VegasL (1/23/2016)

    So I tried with and without malformed data, with and without the regedit changes, and basically all I did was [font="Arial Black"]I added a dummy row of data [/font]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)

    January 23, 2016 at 10:03 pm

    #1854048

  • RE: Database restore automate

    Sree Divya (1/22/2016)

    hi,

    i am planning automate my database new from shared backup location,

    the requirement is need to auto pick up the full backup from shared location and do the restores.

    can...

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

    January 22, 2016 at 10:25 pm

    #1853978

  • RE: usp stored procedure prefix

    william.balogh (1/22/2016)

    Wakey wakey, Forum thread. 🙂

    Right back a'cha and welcome aboard.

    Q: But what if the table becomes a view!?

    A: Not a valid excuse anymore. Do some work, and build the...

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

    January 22, 2016 at 10:10 pm

    #1853977

  • RE: Sub-Grouping by consecutive rows

    Here's the latest readily consumable data with a couple of comments added for other experimenters...

    --===== Conditionally drop the test table to make reruns in SSMS easier.

    ...

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

    January 22, 2016 at 9:07 pm

    #1853971

  • RE: Sub-Grouping by consecutive rows

    There's no need for the Quirky Update in such a case. The "Difference Between Two Row Numbers" will do it, will be faster that the Quirky Update if the...

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

    January 22, 2016 at 8:04 pm

    #1853968

Viewing 15 posts - 18,511 through 18,525 (of 59,072 total)