Click here to Skip to main content
15,899,126 members
Home / Discussions / Work Issues
   

Work Issues

 
GeneralRe: Interviews - like winning the lottery Pin
Vasudevan Deepak Kumar2-Jul-07 21:50
Vasudevan Deepak Kumar2-Jul-07 21:50 
GeneralRe: Interviews - like winning the lottery Pin
minimice5-Jul-07 20:20
minimice5-Jul-07 20:20 
AnswerRe: Interviews - like winning the lottery Pin
DevMentor.org12-Jul-07 12:31
DevMentor.org12-Jul-07 12:31 
GeneralRe: Interviews - like winning the lottery Pin
raajmath4-Sep-07 18:48
raajmath4-Sep-07 18:48 
QuestionGenerating values for Primary Key Pin
tonymathewt19-Jun-07 0:47
professionaltonymathewt19-Jun-07 0:47 
AnswerRe: Generating values for Primary Key Pin
Dave Kreskowiak22-Jun-07 16:54
mveDave Kreskowiak22-Jun-07 16:54 
GeneralRe: Generating values for Primary Key Pin
tonymathewt24-Jun-07 22:40
professionaltonymathewt24-Jun-07 22:40 
GeneralRe: Generating values for Primary Key Pin
Dave Kreskowiak25-Jun-07 13:53
mveDave Kreskowiak25-Jun-07 13:53 
tonymathewt wrote:
in case of yahoo mail/orkut all the mails/scraps will be stored in a single table(not sure).


Maybe. Even so, I'd be willing to bet they haven't handled that many emails, nor do they store them away like this. Remember, I said over 9,000,000,000,000,000,000 ID's. I'd be surprised if the Internet has carried that many emails in the last 10 years combined.


tonymathewt wrote:
Then it would have long crossed this number even if we delete the mails the auto number wont go back, it will only keep incrementing.


Yep. Then it just rolls over and starts back at 0 again. The other option is a composite key, where two or more columns cooperate the generate a unqiue key, like userId and an incremented value.


A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007


GeneralRe: Generating values for Primary Key Pin
tonymathewt25-Jun-07 22:48
professionaltonymathewt25-Jun-07 22:48 
GeneralRe: Generating values for Primary Key Pin
Urs Enzler29-Jun-07 11:27
Urs Enzler29-Jun-07 11:27 
GeneralRe: Generating values for Primary Key Pin
tonymathewt1-Jul-07 16:49
professionaltonymathewt1-Jul-07 16:49 
GeneralRe: Generating values for Primary Key Pin
Urs Enzler1-Jul-07 20:06
Urs Enzler1-Jul-07 20:06 
GeneralRe: Generating values for Primary Key Pin
tonymathewt3-Jul-07 17:12
professionaltonymathewt3-Jul-07 17:12 
GeneralRe: Generating values for Primary Key Pin
Vasudevan Deepak Kumar4-Jul-07 5:06
Vasudevan Deepak Kumar4-Jul-07 5:06 
GeneralRe: Generating values for Primary Key Pin
Dave Kreskowiak5-Jul-07 4:36
mveDave Kreskowiak5-Jul-07 4:36 
QuestionTraining Centers Pin
TheEagle15-Jun-07 4:41
TheEagle15-Jun-07 4:41 
AnswerRe: Training Centers Pin
Vasudevan Deepak Kumar16-Jun-07 2:12
Vasudevan Deepak Kumar16-Jun-07 2:12 
GeneralRe: Training Centers Pin
TheEagle17-Jun-07 0:21
TheEagle17-Jun-07 0:21 
GeneralRe: Training Centers Pin
Vasudevan Deepak Kumar2-Jul-07 1:52
Vasudevan Deepak Kumar2-Jul-07 1:52 
GeneralRe: Training Centers Pin
TheEagle2-Jul-07 10:16
TheEagle2-Jul-07 10:16 
GeneralRe: Training Centers Pin
Dave Kreskowiak2-Jul-07 10:22
mveDave Kreskowiak2-Jul-07 10:22 
QuestionProblem with a J++ component Pin
Raghavanjv14-Jun-07 20:20
Raghavanjv14-Jun-07 20:20 
GeneralRe: Problem with a J++ component Pin
Paul Conrad26-Jan-08 12:18
professionalPaul Conrad26-Jan-08 12:18 
QuestionSoftware Development department structure Pin
Waskira14-Jun-07 1:39
Waskira14-Jun-07 1:39 
GeneralRe: Software Development department structure Pin
Paul Conrad26-Jan-08 12:19
professionalPaul Conrad26-Jan-08 12:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.