Click here to Skip to main content
15,901,001 members
Home / Discussions / Database
   

Database

 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:25
professionalEddy Vluggen19-Feb-14 8:25 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:30
vkEE19-Feb-14 8:30 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:47
professionalGuyThiebaut19-Feb-14 8:47 
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 
Hi,

I'm not sure this is the best way to do this. I have an agent running as a service on thousands of servers. Each server can delete and add several hundred records into one table everyday.

I have set the KEY as an integer using IDENTITY(1,1). During the initial testing I have noticed that SQL Server does not reuse the KEY. This makes me wonder what happens when I've added and deleted 4 Billion records (The max size of an Integer). Does it automatically wrap and I don't need to worry about this?

This is SQL Server, and I'm wondering if I should be doing a database REORGs like we do with DB2.

I know it would of been nice to be able to use a KEY and not worry about this. From what I've read the serial number from each distributor is supposed to be unique however I've run into duplicates right from the start where the distributor is using zero's as the serial number.

Thanks,
Glenn
Glenn

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

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.