Forum Replies Created

Viewing 15 posts - 19,636 through 19,650 (of 59,072 total)

  • RE: Mount Points

    SQL-DBA-01 (9/3/2015)

    I write PS query to get the details.

    Cool. Please share it.

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

    September 6, 2015 at 8:48 pm

    #1824890

  • RE: SQL Performance Elevenses

    Keithyv (8/31/2015)

    Number one should be '...affecting..' not '..effecting..'

    The above should have '...effecting...' not '..effecting..'. 😉

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

    September 6, 2015 at 10:59 am

    #1824878

  • RE: Select statement that needs to use custom grouping

    If this is in the design phase, then anticipate the worst and that would be them adding another level to the mix. Don't say it won't happen because you...

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

    September 6, 2015 at 10:53 am

    #1824877

  • RE: logging without blocking?

    I do such logging from within stored procedures all the time. The key is to NOT include the logging inside an explicit transaction.

    I'll also state that having "long running...

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

    September 6, 2015 at 10:45 am

    #1824876

  • RE: What Kind of DBA Are You?

    This seems to be a near plagiarism of Steve's recent article of the same name. It even has the same poll. What's up with 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)

    September 6, 2015 at 10:40 am

    #1824875

  • RE: Performance tuning of query for PDW

    Grant Fritchey (9/6/2015)

    Jeff Moden (9/6/2015)

    Grant Fritchey (9/6/2015)

    You've shown very simplistic queries that are hitting entire data sets. Your tuning opportunities here are limited to what you can do with hardware.

    +1000......

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

    September 6, 2015 at 10:28 am

    #1824874

  • RE: JSON

    Heh... the correct answer is "Just Some Other Notation" that doesn't belong in a database. 😉

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

    September 6, 2015 at 8:10 am

    #1824864

  • RE: Performance tuning of query for PDW

    Grant Fritchey (9/6/2015)

    You've shown very simplistic queries that are hitting entire data sets. Your tuning opportunities here are limited to what you can do with hardware.

    +1000... unless maybe it's 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)

    September 6, 2015 at 8:06 am

    #1824862

  • RE: Help with Row_Number

    @QQ-485619,

    1. How many rows are in the actual table?

    2. Which column is the clustered index on?

    3. How often does this need to be done?

    4. Is performance...

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

    September 6, 2015 at 8:00 am

    #1824861

  • RE: Percentage of Fragmentation increased after 6 hours

    coolchaitu (9/5/2015)

    Could you please let me know how to check how often an index is inserted

    An index is ALWAYS inserted to whenever a row is inserted into the table it...

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

    September 5, 2015 at 8:18 pm

    #1824844

  • RE: NoSQL inside SQL Server

    Steve Jones - SSC Editor (9/5/2015)

    Comments posted to this topic are about the item <A HREF="/articles/Editorial/131238/">NoSQL inside SQL Server</A>

    Ok... thanks to your article, I finally decided to spend a bit...

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

    September 5, 2015 at 7:32 pm

    #1824842

  • RE: Difference count

    twin.devil (9/4/2015)

    ramrajan (9/4/2015)

    declare @startdate datetime = '2015-03-31 23:59:59.097';

    declare @enddate datetime = '2015-04-01 00:00:00.000';

    returns 2

    Awesome simplified solution with SELECT DATEDIFF(Year, @startdate, @enddate) + 1 AS QUARTER_DIFFERENCE

    Correction Year should be...

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

    September 5, 2015 at 5:07 pm

    #1824839

  • RE: Huge headache to work with big data

    halifaxdal (9/5/2015)

    Jeff Moden (9/3/2015)

    Since "RecordsWritten" is likely different for each instance of any single Network_Group_Name, you'll probably end up with a 40 million row return that simply duplicates the individual...

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

    September 5, 2015 at 5:00 pm

    #1824838

  • RE: First Occurance of the string from text

    With my possibly faulty understanding of the rules (although I think I'm probably pretty close), I came up with this function. As usual, the details, usage example, and some...

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

    September 5, 2015 at 10:11 am

    #1824832

  • RE: First Occurance of the string from text

    [font="Arial Black"]NOTICE: BECAUSE OF ONE OF THE EXTREMELY WIDE POSTS ABOVE, YOU MIGHT NOT BE

    ABLE TO TELL THAT THERE ARE MORE PAGES ON THIS THREAD. SCROLL ALL...

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

    September 5, 2015 at 6:26 am

    #1824826

Viewing 15 posts - 19,636 through 19,650 (of 59,072 total)