Click here to Skip to main content
15,851,711 members
Home / Discussions / Database
   

Database

 
AnswerRe: Database management Pin
Richard MacCutchan19-Jul-15 23:00
mveRichard MacCutchan19-Jul-15 23:00 
AnswerRe: Database management Pin
Mycroft Holmes19-Jul-15 23:32
professionalMycroft Holmes19-Jul-15 23:32 
AnswerRe: Database management Pin
Wendelius20-Jul-15 7:50
mentorWendelius20-Jul-15 7:50 
QuestionDatabase management Pin
Otekpo Emmanuel19-Jul-15 10:38
Otekpo Emmanuel19-Jul-15 10:38 
QuestionRe: Database management Pin
ZurdoDev22-Jul-15 10:48
professionalZurdoDev22-Jul-15 10:48 
Questionlarge database Pin
V.16-Jul-15 22:46
professionalV.16-Jul-15 22:46 
AnswerRe: large database Pin
Wendelius16-Jul-15 23:03
mentorWendelius16-Jul-15 23:03 
GeneralRe: large database Pin
V.16-Jul-15 23:10
professionalV.16-Jul-15 23:10 
Oracle? I know there is a free Oracle version (and a free SQL-Server version), but I'm not sure they'll do the job. Paying for it is a no go here (has to be as cheap as possible), so I'm down with or MySQL or PostgreSQL and I'll take the latter any day Wink | ;-) .

Indexing, I'm not really an expert, but the indexes are limited to 2 (excluding the implicit index on the primary key). So if you have tips there, please shoot.

For this application I'm the designer, architect, tester, developer and, you guessed it, DBA despite my limited knowledge of being a 'real' dba. (there are little or no people doing better at our company so no choice there)

I'll have a look at partitioning.

[EDIT]Ooh, and thanks ! Smile | :) [/EDIT]
V.

(MQOTD rules and previous solutions)

GeneralRe: large database Pin
Wendelius16-Jul-15 23:20
mentorWendelius16-Jul-15 23:20 
GeneralRe: large database Pin
Mycroft Holmes17-Jul-15 15:02
professionalMycroft Holmes17-Jul-15 15:02 
GeneralRe: large database Pin
V.18-Jul-15 1:12
professionalV.18-Jul-15 1:12 
GeneralRe: large database Pin
Mycroft Holmes18-Jul-15 1:45
professionalMycroft Holmes18-Jul-15 1:45 
GeneralRe: large database Pin
V.18-Jul-15 9:25
professionalV.18-Jul-15 9:25 
GeneralRe: large database Pin
Jörgen Andersson20-Jul-15 12:01
professionalJörgen Andersson20-Jul-15 12:01 
AnswerRe: large database Pin
GuyThiebaut18-Jul-15 2:19
professionalGuyThiebaut18-Jul-15 2:19 
GeneralRe: large database Pin
V.18-Jul-15 9:23
professionalV.18-Jul-15 9:23 
GeneralRe: large database Pin
GuyThiebaut18-Jul-15 9:37
professionalGuyThiebaut18-Jul-15 9:37 
QuestionSQL Linq, updating multiple records Pin
jkirkerx15-Jul-15 11:50
professionaljkirkerx15-Jul-15 11:50 
QuestionSave value of PREPARE into a variable Pin
Jassim Rahma14-Jul-15 23:23
Jassim Rahma14-Jul-15 23:23 
AnswerRe: Save value of PREPARE into a variable Pin
Wendelius14-Jul-15 23:45
mentorWendelius14-Jul-15 23:45 
GeneralRe: Save value of PREPARE into a variable Pin
Jassim Rahma15-Jul-15 23:22
Jassim Rahma15-Jul-15 23:22 
GeneralRe: Save value of PREPARE into a variable Pin
Wendelius15-Jul-15 23:51
mentorWendelius15-Jul-15 23:51 
AnswerRe: Save value of PREPARE into a variable Pin
jschell15-Jul-15 11:45
jschell15-Jul-15 11:45 
QuestionSome help with SQL to Linq Conversions Pin
jkirkerx13-Jul-15 8:04
professionaljkirkerx13-Jul-15 8:04 
AnswerRe: Some help with SQL to Linq Conversions Pin
Richard Deeming13-Jul-15 8:18
mveRichard Deeming13-Jul-15 8:18 

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.