Forum Replies Created

Viewing 15 posts - 16,171 through 16,185 (of 59,101 total)

  • RE: Pages Read & Written by a single query

    sgmunson (12/6/2016)

    r5d4 (12/6/2016)

    I'm working in an environment where some very wide tables are present (400+ columns).

    Whilst long term I will be restructuring these and applying some normalization, I need...

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

    #1916262

  • RE: Converting time - from "seconds after midnight"

    sgmunson (12/6/2016)

    Jeff Moden (12/5/2016)

    sgmunson (12/5/2016)

    Jeff Moden (12/5/2016)

    sgmunson (12/5/2016)

    Jeff Moden (12/5/2016)

    Lynn Pettis (12/5/2016)

    Jeff Moden (12/3/2016)

    tacy.highland (12/2/2016)

    The only thing I have against these nice simple answers:

    As you can see, the neat thing...

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

    #1916237

  • RE: relative performance sizing/estimation

    sqlguy-736318 (12/5/2016)

    I'm trying to get a better understanding of relative performance expectations for different types of queries. For example, given a typical SS configuration, what type of response time...

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

    #1916230

  • RE: Troubleshooting

    tarr94 (12/5/2016)

    Thank you for the suggestions so far!

    There have been questions about whether the size increase relates to the data or log file. I can confirm that the sys.master_files.size...

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

    #1916223

  • RE: Converting time - from "seconds after midnight"

    sgmunson (12/5/2016)

    Jeff Moden (12/5/2016)

    sgmunson (12/5/2016)

    Jeff Moden (12/5/2016)

    Lynn Pettis (12/5/2016)

    Jeff Moden (12/3/2016)

    tacy.highland (12/2/2016)

    The only thing I have against these nice simple answers:

    As you can see, the neat thing about nice simple...

    --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, 2016 at 9:31 pm

    #1916139

  • RE: SQl Script runs slow running from SQL Agent

    PJ_SQL (12/5/2016)

    I have a job which runs SQL Script along with function which has started to run slow.

    But when run the same query in the SSMS, it runs fine.

    What could...

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

    #1916135

  • RE: TLOGS

    cbrammer1219 (12/5/2016)

    Thank You, that was it..

    Now that you've found them, you should probably fix them. If something is worth backing up, it's usually worth backing up with the ability...

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

    #1916134

  • RE: Converting time - from "seconds after midnight"

    sgmunson (12/5/2016)

    Jeff Moden (12/5/2016)

    Lynn Pettis (12/5/2016)

    Jeff Moden (12/3/2016)

    tacy.highland (12/2/2016)

    The only thing I have against these nice simple answers:

    As you can see, the neat thing about nice simple answers is 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)

    December 5, 2016 at 7:10 pm

    #1916133

  • RE: Is there a way to extract only credit card numbers from text

    mxy (12/5/2016)

    thanks alan for your time and providing a solution i will test it on my data and make necessary changes if needed based on my real data

    Careful, now... Not...

    --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, 2016 at 6:48 pm

    #1916132

  • RE: Today's Random Word!

    Alan.B (12/5/2016)

    Luis Cazares (12/5/2016)

    crookj (12/5/2016)

    djj (12/5/2016)

    Lane

    Lois

    Lana

    Turner

    Postman

    --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, 2016 at 4:42 pm

    #1916124

  • RE: Best way to automate running adhoc scripts?

    kevaburg (12/5/2016)

    Jeff Moden (12/5/2016)

    kevaburg (12/5/2016)

    Have you maybe thought about creating a file watcher task that can be used as a trigger to automatically run a script when it is dropped...

    --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, 2016 at 4:36 pm

    #1916122

  • RE: Import data in parquet format

    Aaron N. Cutshall (12/5/2016)

    The team did identify a method of pushing the data to SQL Server but this approach requires coordinating the stored procedure execution on SQL Server to occur...

    --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, 2016 at 3:45 pm

    #1916118

  • RE: Converting time - from "seconds after midnight"

    Lynn Pettis (12/5/2016)

    Jeff Moden (12/3/2016)

    tacy.highland (12/2/2016)

    The only thing I have against these nice simple answers:

    As you can see, the neat thing about nice simple answers is that they're nice 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, 2016 at 3:43 pm

    #1916117

  • RE: Best way to automate running adhoc scripts?

    kevaburg (12/5/2016)

    Have you maybe thought about creating a file watcher task that can be used as a trigger to automatically run a script when it is dropped into a folder?

    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)

    December 5, 2016 at 9:26 am

    #1916029

  • RE: Import data in parquet format

    Just trying to use the right tool for the right thing. As with most things, shredding the parquet format in SQL Server could be done but, like using even...

    --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, 2016 at 9:23 am

    #1916028

Viewing 15 posts - 16,171 through 16,185 (of 59,101 total)