Forum Replies Created

Viewing 15 posts - 21,451 through 21,465 (of 59,098 total)

  • RE: Changing the clustered index

    ScottPletcher (2/27/2015)

    Your clustered index key(s) doesn't(don't) have to be unique by itself(themselves); SQL will take care of that if it needs to.

    ... at possibly quite some cost if the clustered...

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

    February 27, 2015 at 2:51 pm

    #1780804

  • RE: Can't remove BLOB data from datafiles

    Fandy08 (2/27/2015)

    I made some test with varbinary(max) datatype (instead of image) and the following sequence works, LOB data is released and canceled from database.

    So the problem is limited to (deprecated)...

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

    February 27, 2015 at 2:45 pm

    #1780802

  • RE: Is there a way

    Grant Fritchey (2/27/2015)

    Instead, I'd go with a more standard approach:

    Heh... why? Portability? 😛

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

    February 27, 2015 at 2:41 pm

    #1780801

  • RE: String as primary key

    Yes... at the "tipping point", a table scan will occur instead. More correctly on a clustered table, a clustered index scan will occur. On very large tables, having...

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

    February 27, 2015 at 12:18 pm

    #1780748

  • RE: String as primary key

    ScottPletcher (2/27/2015)

    Eric M Russell (2/27/2015)

    As a general rule, the clustered key should be sequentially incremented (to avoid page splits and accumulating fragmentation) and it should be narrow, because it will...

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

    February 27, 2015 at 11:37 am

    #1780736

  • RE: String as primary key

    N_Muller (2/26/2015)

    I have tables in database where a VARCHAR(50) string is unique identifier. The database currently has an integer identity column as clustered primary key, and there's a non-clustered...

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

    February 27, 2015 at 8:53 am

    #1780641

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/26/2015)

    ... Mark one off, 1 day on the calendar to go. 1 day on the calendar to go, 1 day to go, ...

    I'm a bit late on my...

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

    February 27, 2015 at 8:41 am

    #1780638

  • RE: index maintenance

    SQLJay (2/26/2015)

    Hello all,

    We use an ERP system that is leveraging SQL2008R2 x64 database. Some of the ERP tables are massive holding close to 275 million rows of data.

    Our work environment...

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

    February 27, 2015 at 8:19 am

    #1780627

  • RE: Nested Cursor example

    @gopi6417,

    This would make a great article. You should write it up and submit it to the folks on this site.

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

    February 27, 2015 at 7:48 am

    #1780616

  • RE: Top most manager name with out CTE

    Sreepathi1987 (2/26/2015)

    How can get this result with out using CTE. using CTE I got. But i need with out CTE

    because there are other conditions and need to append 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)

    February 26, 2015 at 5:16 pm

    #1780436

  • RE: Top most manager name with out CTE

    Lowell (2/26/2015)

    recursive CTE is the way to go. no doubt about it, and no way around it.

    just stick the top results of your recursive query in a temp table...

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

    February 26, 2015 at 5:15 pm

    #1780435

  • RE: Export Fixed Width

    elee1969 (2/26/2015)

    Is using Ragged Right adding another column?

    What's preventing you from trying it to 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)

    February 26, 2015 at 5:09 pm

    #1780432

  • RE: Nested Cursor example

    There's no question here. The third select on the original post shows the set-based replacement for the cursors. The title truly reflects what was posted... it's an example....

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

    February 26, 2015 at 5:03 pm

    #1780431

  • RE: Share your best possible answers--

    Moin Ul Haque (2/26/2015)

    Jeff Moden (2/25/2015)

    Moin Ul Haque (2/25/2015)

    I can quote my own experience here - Out of need, I was asked to develop a database maintenance solution which would...

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

    February 26, 2015 at 5:00 pm

    #1780430

  • RE: Are the posted questions getting worse?

    Steve Thompson-454462 (2/26/2015)

    Jeff Moden (2/24/2015)

    Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences....

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

    February 26, 2015 at 3:46 pm

    #1780422

Viewing 15 posts - 21,451 through 21,465 (of 59,098 total)