Forum Replies Created

Viewing 15 posts - 43,516 through 43,530 (of 59,101 total)

  • RE: Random problems

    drogers (6/9/2009)

    Jeff Moden (6/9/2009)

    RAND() in T-SQL works exactly the same way as RAND() in any computer language.... one row or value at a time.

    No, it doesn't work at all like...

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

    June 9, 2009 at 6:59 pm

    #1007139

  • RE: Random problems

    Heh... in that case, no. NEWID() is random enough as a seed.

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

    June 9, 2009 at 12:18 pm

    #1006982

  • RE: Are the posted questions getting worse?

    GilaMonster (6/9/2009)

    Gee Barry

    RBarryYoung (6/9/2009) Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without any constant factors) of its execution run-time as a function of the length...

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

    June 9, 2009 at 12:16 pm

    #1006981

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/9/2009)

    Jeff Moden (6/9/2009)

    Lynn Pettis (6/9/2009)

    Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...

    Which tread?...

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

    June 9, 2009 at 12:11 pm

    #1006978

  • RE: Random problems

    Mike C (6/9/2009)

    Someguy (6/9/2009)

    OK. I'll be the one to ask the dumb question:

    Most languages have a random function that does not require you to add seeds and/or do other things...

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

    June 9, 2009 at 12:07 pm

    #1006974

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/9/2009)

    Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...

    Which tread? I must bear...

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

    June 9, 2009 at 10:29 am

    #1006853

  • RE: Random problems

    vzurkowski (6/9/2009)

    Exactly!

    NEWID() creates a unique identifier.

    Is it randomly distributed over as set of charater strings of certain length, or something like that? Otherwise, it is not clear RAND(checksum(newid())) is unformly...

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

    June 9, 2009 at 9:55 am

    #1006827

  • RE: Random problems

    Heh... nope... formatting not fixed. The code window removed blank lines and when you copy from the code window and paste into SSMS using IE, all the leading spaces...

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

    June 9, 2009 at 9:47 am

    #1006816

  • RE: Random problems

    Steve Jones - Editor (6/9/2009)

    The formatting is fixed, or should be. Please let me know if it is still messed up.

    That's GREAT! Heh... you know I'll be testing 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)

    June 9, 2009 at 9:40 am

    #1006807

  • RE: Random problems

    woolfson (6/9/2009)

    This is brilliant; I have always struggled with providing a unique identifier to a set of data after the data has already been written to the table, and it's...

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

    June 9, 2009 at 9:39 am

    #1006804

  • RE: Random problems

    Here's a simple test for the floating point stuff. Works fine, fails safe, and drains to the bilge. 😛

    [font="Courier New"] SELECT STR(FLOOR(d.N*100)/100,4,2), COUNT(*)

       FROM (

             SELECT TOP 1000000

                    RAND(CHECKSUM(NEWID())) * 5 AS N

               FROM Master.dbo.SysColumns sc1

              CROSS JOIN Master.dbo.SysColumns sc2

            )d

      GROUP BY STR(FLOOR(d.N*100)/100,4,2)

      ORDER BY STR(FLOOR(d.N*100)/100,4,2)[/font]

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

    June 9, 2009 at 9:15 am

    #1006775

  • RE: Random problems

    Jeff Moden (6/9/2009)

    vzurkowski (6/9/2009)

    To "chose at random from 1,..,5" usually means to chose from 1,..,5 in such a way that any outcome has the same probability of being selected.

    Assuming T-SQL...

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

    June 9, 2009 at 9:06 am

    #1006763

  • RE: Random problems

    vzurkowski (6/9/2009)

    To "chose at random from 1,..,5" usually means to chose from 1,..,5 in such a way that any outcome has the same probability of being selected.

    Assuming T-SQL RAND() has...

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

    June 9, 2009 at 8:53 am

    #1006753

  • RE: Random problems

    Peso (6/9/2009)

    And it's also well established that

    ABS(CHECKSUM(NEWID())) % 100

    gives random numbers between 0 and 99 with very high, good and even distribution.

    I used to do the coversion using Varbinary 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)

    June 9, 2009 at 8:50 am

    #1006749

  • RE: Random problems

    charles.flock (6/9/2009)

    The XLeratorDB function library inlcudes a RANDBETWEEN scalar function which works just like the EXCEL RANDBETWEEN function. You could have just included RANDBETWEEN(1, 5) in your select 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)

    June 9, 2009 at 8:45 am

    #1006742

Viewing 15 posts - 43,516 through 43,530 (of 59,101 total)