Click here to Skip to main content
14,545,459 members
   

Database

 
GeneralRe: Billion rows Pin
jschell17-Mar-18 5:52
Memberjschell17-Mar-18 5:52 
GeneralRe: Billion rows Pin
Jörgen Andersson17-Mar-18 7:39
professionalJörgen Andersson17-Mar-18 7:39 
GeneralRe: Billion rows Pin
jschell24-Mar-18 6:18
Memberjschell24-Mar-18 6:18 
GeneralRe: Billion rows Pin
Jörgen Andersson24-Mar-18 8:18
professionalJörgen Andersson24-Mar-18 8:18 
GeneralRe: Billion rows Pin
jschell31-Mar-18 6:56
Memberjschell31-Mar-18 6:56 
GeneralRe: Billion rows Pin
Jörgen Andersson31-Mar-18 23:25
professionalJörgen Andersson31-Mar-18 23:25 
QuestionIdentity behavior in sql server 2008 and 2012 Pin
VK197-Mar-18 10:02
MemberVK197-Mar-18 10:02 
SuggestionRe: Identity behavior in sql server 2008 and 2012 Pin
CHill608-Mar-18 8:04
mveCHill608-Mar-18 8:04 
The fact you have a while-loop is filling me horror. However, without being able to see the SP code we can't possibly comment on what might be going wrong.
You have contradicted yourself however, you stated
Quote:
We insert an initial value wherein the identity key value is -1,
but you state
Quote:
Both server have the table's field name defined with identity_seed as 0, and increment as 1.
Without checking I can't confirm, but perhaps there was a hole in 2008 that allowed you to trample all over the IDENTITY column.
You should use IDENTITY (-1,1) if you want the first key to be -1 (but I suspect you don't).
Try posting the code so we can suggest ways of improving it ... like getting rid of the WHILE loop Laugh | :laugh:
AnswerRe: Identity behavior in sql server 2008 and 2012 Pin
Richard Deeming8-Mar-18 9:14
mveRichard Deeming8-Mar-18 9:14 
PraiseRe: Identity behavior in sql server 2008 and 2012 Pin
CHill608-Mar-18 9:37
mveCHill608-Mar-18 9:37 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
VK199-Mar-18 7:43
MemberVK199-Mar-18 7:43 
AnswerRe: Identity behavior in sql server 2008 and 2012 Pin
jschell10-Mar-18 10:30
Memberjschell10-Mar-18 10:30 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
VK1912-Mar-18 2:27
MemberVK1912-Mar-18 2:27 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
jschell14-Mar-18 15:16
Memberjschell14-Mar-18 15:16 
Questionmerge to output matched and not matched Pin
indian14328-Feb-18 11:09
Memberindian14328-Feb-18 11:09 
AnswerRe: merge to output matched and not matched Pin
Jörgen Andersson7-Mar-18 11:07
professionalJörgen Andersson7-Mar-18 11:07 
Questionsql query to get code with max rank Pin
Member 927852427-Feb-18 6:55
MemberMember 927852427-Feb-18 6:55 
AnswerRe: sql query to get code with max rank Pin
Richard Deeming27-Feb-18 7:58
mveRichard Deeming27-Feb-18 7:58 
AnswerRe: sql query to get code with max rank Pin
Paket Wisata Lombok28-Feb-18 6:01
professionalPaket Wisata Lombok28-Feb-18 6:01 
QuestionUnable to find Postgresql data source in Entity Data Model Wizard Pin
Sudhir Dehade27-Feb-18 1:19
MemberSudhir Dehade27-Feb-18 1:19 
Rant[REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Richard Deeming27-Feb-18 2:12
mveRichard Deeming27-Feb-18 2:12 
RantRe: [REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Richard Deeming27-Feb-18 2:20
mveRichard Deeming27-Feb-18 2:20 
GeneralRe: [REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Richard Deeming27-Feb-18 2:26
mveRichard Deeming27-Feb-18 2:26 
GeneralRe: [REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Sudhir Dehade27-Feb-18 2:30
MemberSudhir Dehade27-Feb-18 2:30 
QuestionTable Database Advice Pin
JackMisani22-Feb-18 0:36
MemberJackMisani22-Feb-18 0:36 

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.