Viewing 15 posts - 31 through 45 (of 46 total)
Whil;e I agree that data should not be changed without careful consideration, I also have to deal with the very problem discussed in the editorial and yet I am required...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
April 7, 2010 at 12:23 pm
Hiro Protaganist will come after you with his swords if you use optional parameters past 137.
No worries! Although, the future release having 142 parameters was plagued by the Hiro Protaganist...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
April 1, 2010 at 10:58 am
Apparently, you haven't upgraded to the latest TimeWarp Service Pack because that gives you another 119 parameters (including the TimeWarpResetCentury parameter), thus bringing the total available parameters up to 256.:w00t:
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
April 1, 2010 at 9:47 am
cfradenburg (3/26/2010)
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 29, 2010 at 4:15 pm
Not if you reseed the column or use IDENTITY_INSERT to insert values. If an IDENTITY column doesn't have a unique constraint or index then it may not be unique.
As...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 2, 2010 at 5:09 pm
However, from a design perspective, using natural keys, superkeys, and abstract keys derived from natural keys can produce powerful design benefits.
This is true, from a design perspective. However, the...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 2, 2010 at 4:26 pm
Les Cardwell (3/1/2010)
Steve Jones - Editor (3/1/2010)
...A PK has 'meaning', and creates business dependencies throughout the domain...
Codd is sputtering... :pinch:
Actually, A PK (or Primary Key) is the primary means within...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 2, 2010 at 11:24 am
Les,
The real atrocity is when one uses an identity, but fails to make the PK unique.
Excuse me but what DBMS allows you to create a P that is NO...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 2, 2010 at 10:50 am
An email address is a perfectly reasonable unique identifier provided you have the ability to change it.
David,
You have got to be kindding. Not everyone has an email address and...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 2, 2010 at 10:41 am
[quote-0There's nothing wrong with a GUID primary key, as long as it is PRIMARY KEY NONCLUSTERED[/quote-0]
True . . . unfortunately, far too often, those who do not realize the true...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 1, 2010 at 8:42 am
Steve,
Your comment about "when in doubt . . . " struck a nerve on me. I will agree with the "when in doubt, add the INT Identity colummn"; however,...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
March 1, 2010 at 8:20 am
For what it is worth, I think it all depends on the contract with the client, the way the requirements were stated, the extent to which the work previously done...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
February 19, 2010 at 12:21 pm
Steve Jones - Editor (1/26/2010)
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
January 26, 2010 at 8:16 am
ben.mcintyre (1/13/2010)
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
January 14, 2010 at 3:08 pm
Some years back, I was contracted as an "Interim IT Manager" at a company in Memphis, TN, during the transition from local ownership and IT processing to a regional IT...
Ralph D. Wilson II
Development DBA
"Give me 6 hours to chop down a tree and I will spend the first 4 sharpening the ax."
A. Lincoln
September 8, 2009 at 7:45 am
Viewing 15 posts - 31 through 45 (of 46 total)