Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,291 through 37,305 (of 59,072 total)

RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Heh... Tom is definitely one of the good guys.
Part of his last statement in his mantra is actually part of the first statement in mine...
"you might want to seriously think...
--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 14, 2010 at 11:18 am

#1207041
RE: Parsing Parameters in a Stored Procedure

Adam Gojdas (8/13/2010)
Jeff Moden (8/12/2010)
Someone already said it... I'd love to read that article. Would you post the URL on this thread so we can take a peek? ...
--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:47 pm

#1207002
RE: Are the posted questions getting worse?

jcrawf02 (8/12/2010)
I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of 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 11:25 pm

#1206999
RE: Are the posted questions getting worse?

Paul White NZ (8/12/2010)
What sort of hint did you have in mind? Index hints don't work with table variables, and you can't give the PRIMARY KEY or UNIQUE constraints...
--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:11 pm

#1206997
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

Viewing 15 posts - 37,291 through 37,305 (of 59,072 total)