Forum Replies Created

Viewing 15 posts - 36,286 through 36,300 (of 59,102 total)

  • RE: Are There That Many GUIDs?

    Thomas-282729 (10/24/2010)

    1) DISK SPACE isn't what is important, it is THROUGHPUT, and that is dramatically affected by the quadruple-int-sized GUIDs. MEMORY is a precious commodity (on most systems) for 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)

    October 25, 2010 at 7:55 am

    #1241580

  • RE: Hierarchy Structure SQL Query

    Oh my. KSeet... allow me to apologize for 1.2 million members. You did absolutely everything right in posting table structure, data, desired results, etc, etc, and, still, no...

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

    October 24, 2010 at 11:39 pm

    #1241417

  • RE: Sequence-numbering groups

    Paul White NZ (10/23/2010)

    Jeff Moden (10/23/2010)

    Do the source (##temp) and destination (##Results) tables need to be global tables in order for the solution that you posted to work?

    Hi Jeff,

    The most...

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

    October 24, 2010 at 10:24 pm

    #1241405

  • RE: Sequence-numbering groups

    ChrisM@home (10/24/2010)

    Jeff Moden (10/22/2010)

    ... we'll have a drag race. 🙂

    Quirky Update would win this one Jeff, by a factor of about 7 - we both know that 🙂

    I don't...

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

    October 24, 2010 at 10:19 pm

    #1241404

  • RE: How to use PIVOT in this case?

    WayneS (10/13/2010)

    bhushan.bagul (10/13/2010)

    thanks for your reply!!!

    Glad to be of help. Does it work right for you?

    Heh... don'cha just love 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)

    October 24, 2010 at 8:00 pm

    #1241397

  • RE: Faster way to do Top N Order By Desc?

    Donalith (10/14/2010)

    How can I take out the coalesce when it's possible to have a null value there?

    I'll look at the covering index though, that would be a good place 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)

    October 24, 2010 at 7:58 pm

    #1241396

  • RE: Recursive Query

    sridharkannan7 (10/15/2010)

    I've a table with data shown as below

    DetailsID FollowupID

    1 0

    2 ...

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

    October 24, 2010 at 7:50 pm

    #1241395

  • RE: Compound interest query

    keymoo (10/19/2010)

    Thanks very much for your help. Exactly what I needed.

    Just make sure you follow the rules and add the safety check that Lutz wrote about. The code being...

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

    October 24, 2010 at 7:42 pm

    #1241394

  • RE: T-SQL for getting string function

    mpalaparthi (10/18/2010)

    Hello SQL Experts,

    I have a question.... I have 3 tables (table1, table 2 and table3)

    table1: ...

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

    October 24, 2010 at 7:35 pm

    #1241393

  • RE: Identity column concurrency

    Hardy21 (10/21/2010)

    I was thinking that due to multiple user is entering the data at same time, it may generate primary key violation.

    Read up on it in Books Online... you'll feel...

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

    October 24, 2010 at 7:29 pm

    #1241391

  • RE: Serial # generation

    mike 57299 (10/19/2010)

    I have the following procedure:

    DECLARE @id int

    DECLARE @result table(id id)

    update generatepk

    ...

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

    October 24, 2010 at 7:26 pm

    #1241390

  • RE: Odd String Replacement of Characters

    If there's always two dashes, REVERSE (especially two reverses) is a bit expensive. This will work if there's always two dashes and be a bit faster.

    DECLARE @FileName VARCHAR(50)

    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)

    October 24, 2010 at 7:13 pm

    #1241389

  • RE: Part of a String

    AndrewSQLDBA (10/18/2010)

    Thanks WildCat

    I figured it out right after another coffee.

    I will keep your sample code for future queries.

    Thanks again

    Andrew SQLDBA

    Two way street here, Andrew... can you please post what 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)

    October 24, 2010 at 12:32 pm

    #1241356

  • RE: How to How to execute a concatenated query in a procedure

    SeanLange (10/21/2010)

    I would highly recommend you follow the suggested links above. Read them and understand what they are saying. Keep in mind this code I wrote is untested and HIGHLY...

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

    October 24, 2010 at 12:31 pm

    #1241355

  • RE: Combine sql Queries

    I'm not sure why everyone thinks this stuff has to be done in a single query. And, it probably should NOT be done in a single query. Create...

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

    October 24, 2010 at 12:24 pm

    #1241352

Viewing 15 posts - 36,286 through 36,300 (of 59,102 total)