Click here to Skip to main content
15,906,341 members
Home / Discussions / Database
   

Database

 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:59
vkEE19-Feb-14 8:59 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 10:26
professionalGuyThiebaut19-Feb-14 10:26 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:59
professionalEddy Vluggen19-Feb-14 8:59 
AnswerRe: begin tran in sql server 2008 Pin
Corporal Agarn19-Feb-14 8:22
professionalCorporal Agarn19-Feb-14 8:22 
QuestionSQL Server and IDENTITY Pin
gmhanna18-Feb-14 8:33
gmhanna18-Feb-14 8:33 
AnswerRe: SQL Server and IDENTITY Pin
David Mujica18-Feb-14 8:43
David Mujica18-Feb-14 8:43 
GeneralRe: SQL Server and IDENTITY Pin
gmhanna18-Feb-14 9:32
gmhanna18-Feb-14 9:32 
GeneralRe: SQL Server and IDENTITY Pin
Richard Deeming18-Feb-14 11:04
mveRichard Deeming18-Feb-14 11:04 
gmhanna wrote:
that only moves the potential problem, doesn't fix it.

How much data are you inserting? OMG | :OMG:

Assuming 1,000,000 servers, each inserting 1,000,000 records per day, it would take you just under 25,252 years 332 days to use up the capacity of a bigint column starting at 1 and ignoring negative keys. If you start at the minimum value, it would take just under 50,505 years 298 days.

At that point, I think it's fair to say it's Someone Else's Problem.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


JokeRe: SQL Server and IDENTITY Pin
ZurdoDev18-Feb-14 15:31
professionalZurdoDev18-Feb-14 15:31 
AnswerRe: SQL Server and IDENTITY Pin
Mycroft Holmes18-Feb-14 11:46
professionalMycroft Holmes18-Feb-14 11:46 
AnswerRe: SQL Server and IDENTITY Pin
S Douglas26-Feb-14 8:24
professionalS Douglas26-Feb-14 8:24 
QuestionOLAP Cubes in BIDS for Salesforce and PRISM Pin
Karina Notka18-Feb-14 6:30
Karina Notka18-Feb-14 6:30 
AnswerRe: OLAP Cubes in BIDS for Salesforce and PRISM Pin
S Douglas26-Feb-14 8:54
professionalS Douglas26-Feb-14 8:54 
QuestionDelete from MySQL + select affected Pin
Member 993503818-Feb-14 3:41
Member 993503818-Feb-14 3:41 
AnswerRe: Delete from MySQL + select affected Pin
Eddy Vluggen18-Feb-14 7:04
professionalEddy Vluggen18-Feb-14 7:04 
AnswerRe: Delete from MySQL + select affected Pin
ZurdoDev18-Feb-14 15:33
professionalZurdoDev18-Feb-14 15:33 
Questionoracle transaction with multi OracleConnection c # ? Pin
Member 1059782417-Feb-14 9:19
Member 1059782417-Feb-14 9:19 
AnswerRe: oracle transaction with multi OracleConnection c # ? Pin
Shameel18-Feb-14 0:00
professionalShameel18-Feb-14 0:00 
AnswerRe: oracle transaction with multi OracleConnection c # ? Pin
Simon_Whale18-Feb-14 0:46
Simon_Whale18-Feb-14 0:46 
QuestionHandling ISODate in mongoDB when Deserializing from JSON Pin
ThetaClear16-Feb-14 19:48
ThetaClear16-Feb-14 19:48 
QuestionWhere to do the processing Pin
Mycroft Holmes15-Feb-14 22:28
professionalMycroft Holmes15-Feb-14 22:28 
AnswerRe: Where to do the processing Pin
Eddy Vluggen15-Feb-14 23:25
professionalEddy Vluggen15-Feb-14 23:25 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:14
professionalMycroft Holmes16-Feb-14 1:14 
AnswerRe: Where to do the processing Pin
Kornfeld Eliyahu Peter15-Feb-14 23:30
professionalKornfeld Eliyahu Peter15-Feb-14 23:30 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:05
professionalMycroft Holmes16-Feb-14 1:05 

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.