Click here to Skip to main content
15,867,488 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Optimization Pin
Richard MacCutchan16-Feb-15 21:33
mveRichard MacCutchan16-Feb-15 21:33 
AnswerRe: SQL Optimization Pin
Corporal Agarn17-Feb-15 1:45
professionalCorporal Agarn17-Feb-15 1:45 
AnswerRe: SQL Optimization Pin
Mycroft Holmes17-Feb-15 14:03
professionalMycroft Holmes17-Feb-15 14:03 
GeneralRe: SQL Optimization Pin
Chaminda Bandara17-Feb-15 19:06
professionalChaminda Bandara17-Feb-15 19:06 
GeneralRe: SQL Optimization Pin
Mycroft Holmes18-Feb-15 1:14
professionalMycroft Holmes18-Feb-15 1:14 
QuestionVersioned data strategy Pin
LostTheMarbles15-Feb-15 21:08
professionalLostTheMarbles15-Feb-15 21:08 
AnswerRe: Versioned data strategy Pin
GuyThiebaut16-Feb-15 1:44
professionalGuyThiebaut16-Feb-15 1:44 
AnswerRe: Versioned data strategy Pin
Mycroft Holmes17-Feb-15 13:59
professionalMycroft Holmes17-Feb-15 13:59 
Another option is to maintian a heirarchical structure /rootid/child1/child2/, this is what MS heirarchiy structure does, I use a varchar instead of the binary data type but the concept is excellent.

You can always trace the changes and also find the root and leaf nodes.
Never underestimate the power of human stupidity
RAH

QuestionVB.NET MYSQL sum row values Pin
KipkoechE15-Feb-15 20:51
KipkoechE15-Feb-15 20:51 
AnswerRe: VB.NET MYSQL sum row values Pin
Richard MacCutchan15-Feb-15 22:11
mveRichard MacCutchan15-Feb-15 22:11 
QuestionMYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 4:19
KipkoechE15-Feb-15 4:19 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Afzaal Ahmad Zeeshan15-Feb-15 4:41
professionalAfzaal Ahmad Zeeshan15-Feb-15 4:41 
GeneralRe: MYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 4:46
KipkoechE15-Feb-15 4:46 
GeneralRe: MYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 6:15
KipkoechE15-Feb-15 6:15 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Eddy Vluggen15-Feb-15 8:18
professionalEddy Vluggen15-Feb-15 8:18 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
sanket16415-Feb-15 17:43
sanket16415-Feb-15 17:43 
QuestionSSRS report is not fitting withing Margins Pin
indian14313-Feb-15 13:39
indian14313-Feb-15 13:39 
QuestionEdit SSRS report file Pin
indian14312-Feb-15 14:08
indian14312-Feb-15 14:08 
AnswerRe: Edit SSRS report file Pin
Member 1102161912-Feb-15 19:07
Member 1102161912-Feb-15 19:07 
AnswerRe: Edit SSRS report file Pin
Chris Quinn13-Feb-15 0:25
Chris Quinn13-Feb-15 0:25 
GeneralRe: Edit SSRS report file Pin
indian14313-Feb-15 13:36
indian14313-Feb-15 13:36 
QuestionMYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 2:28
KipkoechE12-Feb-15 2:28 
AnswerRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 3:26
mveRichard Deeming12-Feb-15 3:26 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:06
KipkoechE12-Feb-15 4:06 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 4:20
professionalGuyThiebaut12-Feb-15 4:20 

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.