Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,321 through 37,335 (of 59,098 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (8/13/2010)
Nothing like coming in to work to find out that the server team deployed patches to production boxes, caused an outage, didn't communicate that fact, and did not follow...
--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)

August 13, 2010 at 11:01 pm

#1206996
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

mtillman-921105 (8/12/2010)
Not that I'm trying to put an end to this logic discussion, I'm not: but look. Can't we accept that in certain cases NULLs are useful and in...
--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)

August 13, 2010 at 10:38 pm

#1206994
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

mtillman-921105 (8/12/2010)
I have to disagree with you there Jeff. The utility of SQL Server, and all RDBMS in general, is for business. Why remove it from its context?...
--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)

August 13, 2010 at 10:36 pm

#1206993
RE: Finding Unique Non-Repeating Random Numbers

Brandie Tarvin (8/13/2010)
Jeff Moden (8/13/2010)
You can see that an average of about 520 numbers out of the million duplicate on each run. The run above (not including the dupe...
--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)

August 13, 2010 at 9:19 pm

#1206987
RE: Finding Unique Non-Repeating Random Numbers

Bert De Haes (8/13/2010)
You can easely resolve the "unique" problem by adding a distinct to the select top().
I tried this, and it works fine on SQL 2005. The distinct 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)

August 13, 2010 at 9:16 pm

#1206986
RE: Finding Unique Non-Repeating Random Numbers

James Goodwin (8/13/2010)
Since you brought it up, please explain the semantical differences between a random set and an arbitrary set of numbers.
Jeff,
An arbitrary number is a number that you...
--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)

August 13, 2010 at 6:13 pm

#1206975
RE: Finding Unique Non-Repeating Random Numbers

James Goodwin (8/12/2010)
As AndyC mentions this is not a random set.
However, for this case you don't need a random set, you need an arbitrary set of numbers. (More accurately,...
--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)

August 13, 2010 at 7:59 am

#1206652
RE: Finding Unique Non-Repeating Random Numbers

magarity kerns (8/12/2010)
I understand random numbers for some cases but it seems strange here. If the purpose is to encrypt real EINs then one of the built in encryption...
--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)

August 13, 2010 at 7:57 am

#1206648
RE: Finding Unique Non-Repeating Random Numbers

sql 7342 (8/12/2010)
...not proven to have good distributions...
Ok... since you brought it up, let's see the code that demonstrates what you said. 😉
...and seems a bit slow.
As compared to WHAT?
--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)

August 13, 2010 at 7:52 am

#1206641
RE: Finding Unique Non-Repeating Random Numbers

CELKO (8/12/2010)
This is called an additive congruency generator, as oppsd to a random number generator. Here is the formula for a 31-bit additive congruency generator.
UPDATE generator
...
--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)

August 13, 2010 at 7:49 am

#1206637
RE: Finding Unique Non-Repeating Random Numbers

AndyC London (8/12/2010)
There is a terminolgy issue here. The numbers in this sequence are not actually random as we could predict the next number in the sequence by looking at...
--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)

August 13, 2010 at 7:47 am

#1206636
RE: Finding Unique Non-Repeating Random Numbers

sql 7342 (8/12/2010)
Great post. Good example of use of random numbers.
Rand versus NewID has been discussed. Rand only runs once per query, NewID is like other functions, but requires conversion...
--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)

August 13, 2010 at 7:41 am

#1206632
RE: Finding Unique Non-Repeating Random Numbers

jcrawf02 (8/12/2010)
Jeff likes to use ABS(CHECKSUM(NEWID())) to generate random numbers, I haven't done any testing on it like you did, so don't know if it has issues with repetition or...
--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)

August 13, 2010 at 7:37 am

#1206628
RE: Finding Unique Non-Repeating Random Numbers

wppatton (8/12/2010)
Foks,
It is NOT a dating website. It's a seating chart request from a business partner. I haven't touched TSQL in awhile so I thought I would bang 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)

August 13, 2010 at 6:23 am

#1206556
RE: Finding Unique Non-Repeating Random Numbers

wppatton (8/12/2010)
Jim,
It's not even close to being a homework problem. I wouldn't post homework for someone else to do. It's real world problem being brought to me by a...
--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)

August 13, 2010 at 6:20 am

#1206554

Viewing 15 posts - 37,321 through 37,335 (of 59,098 total)