Forum Replies Created

Viewing 15 posts - 24,826 through 24,840 (of 59,099 total)

  • RE: Updating 2 databases at the exact same time

    Sean Lange (1/6/2014)

    Oooooo.... the classic MK I. I haven't seen one of those in a long time. It was one of my favorites even though the velocity 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)

    January 7, 2014 at 2:42 pm

    #1678244

  • RE: optimal indexes for a table that is read frequently

    Sridhar-137443 (1/6/2014)

    Hi, Thank you for the response. Please see my answers

    1. What column(s) is the clustered index on and what are their datatypes?

    we have a column named "Uniqueid". It 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)

    January 7, 2014 at 2:38 pm

    #1678242

  • RE: t-sql key on a table

    ScottPletcher (1/7/2014)

    Even if some splits do occur, the table won't "easily double in size", since that would require every page to split.

    Automatically adding an identity as the clustering key by...

    --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 7, 2014 at 2:20 pm

    #1678234

  • RE: DBAs Need to Learn to Develop

    Steve Jones - SSC Editor (1/7/2014)

    Jeff Moden (1/6/2014)

    Considering the "DBAs" that I've interviewed in the last six months, I'd say they shouldn't take the time learning more about development... they...

    --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 7, 2014 at 2:09 pm

    #1678230

  • RE: DBAs Need to Learn to Develop

    eccentricDBA (1/7/2014)

    I agree that a DBA should learn how to develop. At the very least they should learn how to use a scripting language (dos batch, bash, cscript, vbscript,...

    --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 7, 2014 at 2:05 pm

    #1678227

  • RE: DBAs Need to Learn to Develop

    Gary Varga (1/7/2014)

    There are too many people in the technical side of IT who do not have a foundation in IT knowledge. We should all understand binary, logic, declarative programming,...

    --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 7, 2014 at 8:26 am

    #1678105

  • RE: Hidden Formatting Troubles with STR() (SQL Spackle)

    paul.goldstraw (1/7/2014)

    Thanks Jeff, makes sense. If someone asked me to right justify some text I think the quicker solution would be closer to what I would have attempted anyway as...

    --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 7, 2014 at 7:17 am

    #1678067

  • RE: Hidden Formatting Troubles with STR() (SQL Spackle)

    Sure. There are actually three implied reasons. The first is that zeros are simply easier to see and verify the presence of in an article than a blob...

    --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 7, 2014 at 7:01 am

    #1678059

  • RE: T-SQL Help

    dwain.c (1/6/2014)

    Jeff Moden (1/6/2014)

    [EDIT]... hmmm... although.... it might just be a RANK problem, now that I think about it a bit more.

    OK. You've got my attention. I've see...

    --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 7, 2014 at 12:04 am

    #1677970

  • RE: T-SQL Help

    dwain.c (1/6/2014)

    I agree that I don't think the OP's input data matches the stated, expected results. However I do believe what he's looking for would be something like this:

    SELECT...

    --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 6, 2014 at 11:59 pm

    #1677969

  • RE: T-SQL Help

    Christian Graus (1/6/2014)

    lead/lag is awesome, I have 2012 🙂

    And I was wrong again. He's after a count, so I'm not sure how lead/lag help, esp as he wants 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 6, 2014 at 11:41 pm

    #1677966

  • RE: Table Partition - Can't drop a file group

    ayemya (1/6/2014)

    Hi Keith,

    Thank you so much for looking into my question. I have watched Kendra's video and tried out your script. It works perfect.

    In my case, the partition was already...

    --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 6, 2014 at 11:29 pm

    #1677965

  • RE: t-sql key on a table

    ScottPletcher (1/6/2014)

    Actually, it is a terrible idea to add an identity to this table.

    Depending on your specific data, future inserts could be sequential anyway. Even if not, rows 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)

    January 6, 2014 at 10:53 pm

    #1677955

  • RE: t-sql key on a table

    Ed Wagner (1/3/2014)

    For this table, it is fine if you add a column as IDENTITY (1, 1) and define it as a primary key. It'll be a 4-byte key.

    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)

    January 6, 2014 at 10:23 pm

    #1677951

  • RE: t-sql key on a table

    Christian Graus (1/6/2014)

    Thanks - good to know.

    Just so you don't think that I'm making this up, here's the entry from Books Online under the title of "Creating and Modifying PRIMARY...

    --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 6, 2014 at 10:17 pm

    #1677950

Viewing 15 posts - 24,826 through 24,840 (of 59,099 total)