Click here to Skip to main content
       

Database

 
AnswerRe: What happens with auto-incremented value on rollback? PinmvpEddy Vluggen30-Jan-13 23:50 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc31-Jan-13 0:17 
NewsRe: What happens with auto-incremented value on rollback? PinmvpEddy Vluggen31-Jan-13 4:16 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens31-Jan-13 6:18 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberPIEBALDconsult30-Jan-13 11:29 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 23:09 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpmpdesign30-Jan-13 20:46 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberJörgen Andersson30-Jan-13 8:37 
I do know, and I did tell you to rethink your design.
 
If you had used Oracle it would have been much worse, Oracle cache the sequences, so if you restart the server you can get a gap of twenty numbers. and if you have a cluster server they won't even be in order.
(<for the nitpicks> I know it's a setting, but if you want higher performance you don't change it</for the nitpicks>)
People say nothing is impossible, but I do nothing every day.

AnswerRe: What happens with auto-incremented value on rollback? PinmemberShameel30-Jan-13 4:15 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 6:45 
AnswerRe: What happens with auto-incremented value on rollback? Pinmemberi.j.russell30-Jan-13 5:37 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 6:41 
AnswerRe: What happens with auto-incremented value on rollback? PinmemberMycroft Holmes30-Jan-13 12:44 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberPIEBALDconsult31-Jan-13 4:40 
AnswerRe: What happens with auto-incremented value on rollback? Pinmembergvprabu21-Feb-13 0:02 
QuestionBook recommendation for learning SQL PinmemberLloyd Atkinson29-Jan-13 19:33 
AnswerRe: Book recommendation for learning SQL PinmemberJörgen Andersson30-Jan-13 1:52 
AnswerRe: Book recommendation for learning SQL Pinmemberi.j.russell30-Jan-13 5:34 
AnswerRe: Book recommendation for learning SQL PinmemberSimon_Whale30-Jan-13 6:46 
AnswerRe: Book recommendation for learning SQL Pinmemberdjj5530-Jan-13 7:33 
AnswerRe: Book recommendation for learning SQL Pinmembergvprabu21-Feb-13 0:09 
QuestionCan we delete old records from aspstatetempsessions table? Pinmembermanikantaer29-Jan-13 18:43 
AnswerRe: Can we delete old records from aspstatetempsessions table? Pinmvpthatraja4-Oct-13 21:46 
Questioncontrol AVG cost and close stock Pinmemberkornkimhour29-Jan-13 16:13 
AnswerRe: control AVG cost and close stock Pinmvpthatraja4-Oct-13 21:50 

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

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


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid