Click here to Skip to main content
15,567,466 members
Home / Discussions / Database
   

Database

 
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 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 3:50
professionalEddy Vluggen6-Feb-20 3:50 
Super Lloyd wrote:
Mm.. you seem to recommend Index2 so I am confused by your "Index3" on the first line...
Same as Index2, but with another order of the fields.

Super Lloyd wrote:
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.
That makes those three fields a compound primary key.

Super Lloyd wrote:
Thanks for your feedback and MSDN quotes though! Smile | :)
My pleasure, and seems they know most about Sql Server Thumbs Up | :thumbsup:
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

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 
QuestionOracle SQL query to MS-SQL Pin
Member 951930620-Jan-20 23:37
Member 951930620-Jan-20 23:37 

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.