Forum Replies Created

Viewing 15 posts - 19,666 through 19,680 (of 59,098 total)

  • 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

  • RE: include source feature

    sgmunson (9/4/2015)

    mar.ko (9/2/2015)

    I need to use the same SQL source code in more than one stored proc.

    Is there a way to -include mysql.sql or something like that ?

    How does everyone...

    --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 4, 2015 at 6:40 pm

    #1824796

  • RE: Save query results directly using variables and date/time

    Luis Cazares (9/2/2015)

    You also need to be sure about the server name you're using.

    Nicely done, Luis.

    Just a tip... if it all occurs on the server itself, you don't need 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)

    September 4, 2015 at 6:31 pm

    #1824795

  • RE: Save query results directly using variables and date/time

    Grant Fritchey (9/2/2015)

    I would focus on using PowerShell. You can make the call to the procedure, capture the output to file. It's the most direct mechanism available. You'll have maximum...

    --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 4, 2015 at 6:25 pm

    #1824794

  • RE: Need Windowed Partitioning Help

    Want a cool Sig (9/4/2015)

    Hi Luis, I've never seen this before and I don't see it in the online documentation... how does it work? I always thought you needed...

    --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 4, 2015 at 5:58 pm

    #1824793

Viewing 15 posts - 19,666 through 19,680 (of 59,098 total)