Click here to Skip to main content
13,795,352 members
   

Database

 
GeneralRe: Billion rows Pin
jschell31-Mar-18 8:01
memberjschell31-Mar-18 8:01 
GeneralRe: Billion rows Pin
Mycroft Holmes31-Mar-18 14:40
memberMycroft Holmes31-Mar-18 14:40 
GeneralRe: Billion rows Pin
Jörgen Andersson1-Apr-18 0:13
protectorJörgen Andersson1-Apr-18 0:13 
GeneralRe: Billion rows Pin
jschell6-Apr-18 11:03
memberjschell6-Apr-18 11:03 
AnswerRe: Billion rows Pin
Jörgen Andersson11-Mar-18 23:56
protectorJörgen Andersson11-Mar-18 23:56 
GeneralRe: Billion rows Pin
jschell14-Mar-18 16:15
memberjschell14-Mar-18 16:15 
GeneralRe: Billion rows Pin
Jörgen Andersson14-Mar-18 23:17
protectorJörgen Andersson14-Mar-18 23:17 
GeneralRe: Billion rows Pin
jschell17-Mar-18 6:52
memberjschell17-Mar-18 6:52 
Jörgen Andersson wrote:
If you can store the max(ID) from the previous page I'd recommend trying this instead


I like the idea. Unfortunately the id is not sequential (again not my idea.)

So to do the paged query based on that it would require sorting the primary id then paging on that. So perhaps exactly the same or even less efficient.
GeneralRe: Billion rows Pin
Jörgen Andersson17-Mar-18 8:39
protectorJörgen Andersson17-Mar-18 8:39 
GeneralRe: Billion rows Pin
jschell24-Mar-18 7:18
memberjschell24-Mar-18 7:18 
GeneralRe: Billion rows Pin
Jörgen Andersson24-Mar-18 9:18
protectorJörgen Andersson24-Mar-18 9:18 
GeneralRe: Billion rows Pin
jschell31-Mar-18 7:56
memberjschell31-Mar-18 7:56 
GeneralRe: Billion rows Pin
Jörgen Andersson1-Apr-18 0:25
protectorJörgen Andersson1-Apr-18 0:25 
QuestionIdentity behavior in sql server 2008 and 2012 Pin
VK197-Mar-18 11:02
memberVK197-Mar-18 11:02 
SuggestionRe: Identity behavior in sql server 2008 and 2012 Pin
CHill608-Mar-18 9:04
protectorCHill608-Mar-18 9:04 
AnswerRe: Identity behavior in sql server 2008 and 2012 Pin
Richard Deeming8-Mar-18 10:14
mvpRichard Deeming8-Mar-18 10:14 
PraiseRe: Identity behavior in sql server 2008 and 2012 Pin
CHill608-Mar-18 10:37
protectorCHill608-Mar-18 10:37 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
VK199-Mar-18 8:43
memberVK199-Mar-18 8:43 
AnswerRe: Identity behavior in sql server 2008 and 2012 Pin
jschell10-Mar-18 11:30
memberjschell10-Mar-18 11:30 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
VK1912-Mar-18 3:27
memberVK1912-Mar-18 3:27 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
jschell14-Mar-18 16:16
memberjschell14-Mar-18 16:16 
Questionmerge to output matched and not matched Pin
indian14328-Feb-18 12:09
memberindian14328-Feb-18 12:09 
AnswerRe: merge to output matched and not matched Pin
Jörgen Andersson7-Mar-18 12:07
protectorJörgen Andersson7-Mar-18 12:07 
Questionsql query to get code with max rank Pin
Member 927852427-Feb-18 7:55
memberMember 927852427-Feb-18 7:55 
AnswerRe: sql query to get code with max rank Pin
Richard Deeming27-Feb-18 8:58
mvpRichard Deeming27-Feb-18 8:58 

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.


Advertise | Privacy | Cookies | Terms of Service
Web05 | 2.8.181207.3 | Last Updated 11 Dec 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid