Click here to Skip to main content
15,562,816 members
Home / Discussions / Database
   

Database

 
QuestionCreate a new Primary Key on survey table Pin
learning_new25-Feb-20 13:01
learning_new25-Feb-20 13:01 
AnswerRe: Create a new Primary Key on survey table Pin
Nathan Minier28-Feb-20 7:38
professionalNathan Minier28-Feb-20 7:38 
AnswerRe: Create a new Primary Key on survey table Pin
Eddy Vluggen28-Feb-20 10:48
professionalEddy Vluggen28-Feb-20 10:48 
AnswerRe: Create a new Primary Key on survey table Pin
David Mujica2-Mar-20 4:56
David Mujica2-Mar-20 4:56 
GeneralRe: Create a new Primary Key on survey table Pin
learning_new3-Mar-20 5:28
learning_new3-Mar-20 5:28 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 14:35
Super Lloyd5-Feb-20 14:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 16:09
professionalEddy Vluggen5-Feb-20 16:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 18:38
Super Lloyd5-Feb-20 18:38 
Mm.. you seem to recommend Index2 so I am confused by your "Index3" on the first line...

basically this is a table that aggregate a summary from multiple data sources. id0 and id1 identify the datasource and are small number (between 1 to 9 each) and id2 is the original record id in the foreign datasource.

I am interested to speed up read query...
But.. mmm... I realize this particular query is not too important.. and querying by id2 will be used elsewhere... mmmmm.....

Thanks for your feedback and MSDN quotes though! Smile | :)
A new .NET Serializer
All in one Menu-Ribbon Bar
Taking over the world since 1371!

GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 3:50
professionalEddy Vluggen6-Feb-20 3:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 23:28
professionalJörgen Andersson5-Feb-20 23:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 1:17
mveRichard Deeming6-Feb-20 1:17 
Questionintegrity constraint Pin
Tara112-Feb-20 7:23
Tara112-Feb-20 7:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 9:47
mveWendelius2-Feb-20 9:47 
GeneralRe: integrity constraint Pin
Tara112-Feb-20 10:07
Tara112-Feb-20 10:07 
GeneralRe: integrity constraint Pin
markkuk3-Feb-20 0:48
markkuk3-Feb-20 0:48 
Questiontransaction recovery Pin
Tara112-Feb-20 6:46
Tara112-Feb-20 6:46 
AnswerRe: transaction recovery Pin
Eddy Vluggen3-Feb-20 4:00
professionalEddy Vluggen3-Feb-20 4:00 
QuestionCopy structure of all the tables of one database to another server Pin
Member 1473192331-Jan-20 5:58
Member 1473192331-Jan-20 5:58 
AnswerRe: Copy structure of all the tables of one database to another server Pin
phil.o31-Jan-20 6:12
mvephil.o31-Jan-20 6:12 
AnswerRe: Copy structure of all the tables of one database to another server Pin
Eddy Vluggen3-Feb-20 4:01
professionalEddy Vluggen3-Feb-20 4:01 
Questionintegrity constraint Pin
Tara1129-Jan-20 11:36
Tara1129-Jan-20 11:36 
AnswerRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 11:56
professionalMycroft Holmes29-Jan-20 11:56 
GeneralRe: integrity constraint Pin
Tara1129-Jan-20 12:05
Tara1129-Jan-20 12:05 
GeneralRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 12:21
professionalMycroft Holmes29-Jan-20 12:21 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 10:01
mveWendelius2-Feb-20 10:01 

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.