Viewing 15 posts - 31 through 45 (of 45 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...
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...
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:
April 1, 2010 at 9:47 am
cfradenburg (3/26/2010)
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...
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...
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...
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...
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...
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...
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,...
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...
February 19, 2010 at 12:21 pm
Steve Jones - Editor (1/26/2010)
January 26, 2010 at 8:16 am
ben.mcintyre (1/13/2010)
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...
September 8, 2009 at 7:45 am
Viewing 15 posts - 31 through 45 (of 45 total)