Forum Replies Created

Viewing 15 posts - 20,926 through 20,940 (of 59,098 total)

  • RE: Is it worth to pursue a C# cert for a SQL Dev focused career path?

    dominic cloud (4/27/2015)

    I have the option to pursue a C# certification through my employer. My intended career path is to primarily focus on being a SQL Developer. 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)

    April 28, 2015 at 8:33 am

    #1793955

  • RE: Top expensive queries

    Gary Harding (4/28/2015)

    ...and then there's always SSMS' built-in reports (right-click on the database instance in Object Explorer).

    Presumably they do something very similar to Eirikur's query under the hood, but with...

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

    April 28, 2015 at 8:22 am

    #1793948

  • RE: SQL Send Email - Best solution.

    ShuaibV (4/27/2015)

    Hello

    I wanted to implement the feature to send the email in HTML format from SQL. Which option will be more easy and less resource consumption? Like

    sp_send_dbmail...

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

    April 28, 2015 at 8:15 am

    #1793946

  • RE: What is a "set-based loop?"

    You should see what happens when Halloween protection fails on an incorrectly written UPDATE when all of the conditions are just right. It's fairly unpredictable so nearly impossible 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)

    April 28, 2015 at 7:40 am

    #1793934

  • RE: What is a "set-based loop?"

    Eric M Russell (4/27/2015)

    Jeff Moden (4/26/2015)

    ...

    The other type is probably not what most people would expect. R. Barry Young coined the phrase for these "set based loops" (which 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)

    April 27, 2015 at 11:08 am

    #1793770

  • RE: Running Balance Updation

    vikramchander90 (4/26/2015)

    Row_no will be unique if u do group by acct_id otherwise it will not be unique. I have a sno column which will be unique overall. Yes there 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)

    April 27, 2015 at 10:44 am

    #1793740

  • RE: What is a "set-based loop?"

    Gary Harding (4/27/2015)

    Jeff Moden (4/26/2015)

    You're seriously aware of one of the more famous Pseudo-Cursors there is... a SELECT that uses a Tally Table.

    When I first saw this type of usage...

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

    April 27, 2015 at 5:37 am

    #1793617

  • RE: Reducing Index Fragmentaion during Inserts

    kevaburg (4/26/2015)

    Hi Folks,

    This is my problem.

    We have a database with a table that contains around 180m records. Each day a further 70k are inserted. No records 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)

    April 26, 2015 at 10:19 pm

    #1793561

  • RE: Microsoft Exercise

    If it weren't so true, it actually would be funny. "Upgrade Tuesdays" seems to occur on the 1st Tuesday of each month. That Thursday after, the folks 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)

    April 26, 2015 at 10:16 pm

    #1793558

  • RE: Running Balance Updation

    vikramchander90 (4/26/2015)

    Hi,

    Currently i do not have Primary key defined for table. But i created an index for row_no and account_id column.

    Does the Row_No column have only unique...

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

    April 26, 2015 at 10:05 pm

    #1793557

  • RE: Hi, first post! Interested in "Calls"

    rourrourlogan (4/26/2015)

    I want to find out the sum of the total new insurance policies quickly, I dont want to have to navigate an entire long list of querys to find...

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

    April 26, 2015 at 7:21 pm

    #1793553

  • RE: What is a "set-based loop?"

    Alan.B (4/26/2015)

    Over the past year I have heard some folks around here talk about a "set based loop". What's that all about? Can someone provide an example?

    There are two types...

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

    April 26, 2015 at 7:14 pm

    #1793552

  • RE: Embrace Stored Procedures

    xsevensinzx (4/26/2015)

    Jeff Moden (4/26/2015)

    xsevensinzx (4/25/2015)

    ...if someone came to me and said that the database can store no logic, then it's not the end of the world.

    BWAAAHAAAA!!! If someone gave...

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

    April 26, 2015 at 4:40 pm

    #1793549

  • RE: Embrace Stored Procedures

    xsevensinzx (4/25/2015)

    ...if someone came to me and said that the database can store no logic, then it's not the end of the world.

    BWAAAHAAAA!!! If someone gave me such ridiculous...

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

    April 26, 2015 at 2:46 pm

    #1793546

  • RE: Running Balance Updation

    vikramchander90 (4/26/2015)

    I have below table and few rows as eg

    Create Tableledger

    (

    row_noint,

    acct_idvarchar(255),

    debitnumeric(28,2),

    creditnumeric(28,2),

    balancenumeric(28,2)

    )

    row_noacct_idtran_descdebitcreditbalance

    0Account1Opening BalanceNULLNULL1000.00

    0Account2Opening BalanceNULLNULL500.00

    1Account1SOBI0.00200.00NULL

    2Account1SNP300.000.00NULL

    1Account2SNP100.00200.00NULL

    I need to update the balance column as running balance based on acct_id column as previous balance +...

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

    April 26, 2015 at 2:24 pm

    #1793545

Viewing 15 posts - 20,926 through 20,940 (of 59,098 total)