Forum Replies Created

Viewing 15 posts - 36,346 through 36,360 (of 59,102 total)

  • RE: More efficient way

    sturner (10/19/2010)

    Thanks for making that point GregE.

    Just so the original poster doesn't think I'm a grouch and since others did point a few of the more obvious problems, I...

    --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 19, 2010 at 4:59 pm

    #1239420

  • RE: Else '' Returns a 0?

    gah (10/19/2010)

    CELKO (10/18/2010)

    1) Learn the differences between rows and records, columns and fields; it will help.

    Apologies for going off topic here, but I am confused by this statement above.

    BOL states...

    --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 19, 2010 at 4:46 pm

    #1239415

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/21/2010)

    Paul White NZ (9/21/2010)

    ...

    The current SQL development model is to address a small number of main product features in each new major release. 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 19, 2010 at 4:33 pm

    #1239411

  • RE: Are the posted questions getting worse?

    Paul White NZ (9/21/2010)

    Gianluca Sartori (9/21/2010)

    I agree that some of the new features have been implemented poorly, but I really would like to see those window functions in the next...

    --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 19, 2010 at 4:27 pm

    #1239408

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (9/21/2010)

    Paul White NZ (9/20/2010)

    Steve Jones - Editor (9/20/2010)

    BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote...

    --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 19, 2010 at 4:25 pm

    #1239407

  • RE: How to return last 10 rows of a table?

    mm.sailaja (10/18/2010)

    Hi guys!!

    I know that a table is an unordered. Order by clause gives us the result in a sorted manner. I don't want the result in a sorted order....

    --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 18, 2010 at 5:48 am

    #1238340

  • RE: Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)

    gunapriyan (10/17/2010)

    Dear Sir,

    Thanks for your reply.

    Actually I am developing a software with the help of VB 6.0 and SQL Server 2005.

    In Date Part, Initially i have put DateTime Picker...

    --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 18, 2010 at 5:43 am

    #1238338

  • RE: Date Gap Problem

    Paul White NZ (10/18/2010)

    The original question doesn't give expected output or the number of rows to be processed, so this is a valid alternative:

    SELECT *

    FROM #membership...

    --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 18, 2010 at 5:10 am

    #1238322

  • RE: Date Gap Problem

    Dave Ballantyne (10/18/2010)

    I would be interested in comparative performance over a larger dataset. 😉

    No problem. Here's some test data...

    --===== Expand the test data using "lasagne" copies of the original...

    --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 18, 2010 at 5:06 am

    #1238319

  • RE: UDF Vs Subquery performance

    SQL* (10/17/2010)

    How to make use of UDF or subquery?

    Which is better one with performance considerations?

    thanks

    "It Depends". You have to test each way based on the situation you're trying...

    --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 17, 2010 at 11:07 pm

    #1238227

  • RE: Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)

    My recommendation is to lookup the word REPLACE in Books Online. It'll show you how to easily do such a thing. I'd show you the actual code but...

    --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 17, 2010 at 11:02 pm

    #1238226

  • RE: Are There That Many GUIDs?

    Although having two systems come up with the same GUID is a bit like having two comets appear in the same mile across 14 quadrillion Milky Way galaxies, it can...

    --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 17, 2010 at 10:57 pm

    #1238224

  • RE: Are There That Many GUIDs?

    Eric Russell 13013 (10/12/2010)

    As for global uniqueness, I don't see why the column combination (center_id + cashregister_id + transaction_date) or database id + transaction identity id would not be 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)

    October 17, 2010 at 10:51 pm

    #1238222

  • RE: Are There That Many GUIDs?

    Grant Fritchey (10/12/2010)

    They should be used where appropriate...

    I apologize for puting you on the spot but what do you consider an appropriate use for them is especially since even MS...

    --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 17, 2010 at 10:49 pm

    #1238221

  • RE: When Times are Tough, Do You Rise to the Occasion?

    The answer is the same answer as to anything else... "It Depends".

    --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 17, 2010 at 10:44 pm

    #1238219

Viewing 15 posts - 36,346 through 36,360 (of 59,102 total)