Click here to Skip to main content
15,923,222 members
Home / Discussions / Database
   

Database

 
AnswerRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 21:46
professionalGuyThiebaut19-Feb-14 21:46 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 22:08
Prasad A19-Feb-14 22:08 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 22:24
professionalGuyThiebaut19-Feb-14 22:24 
QuestionUpdate Database for C# application Pin
PDTUM19-Feb-14 6:06
PDTUM19-Feb-14 6:06 
AnswerRe: Update Database for C# application Pin
David Mujica19-Feb-14 8:39
David Mujica19-Feb-14 8:39 
AnswerRe: Update Database for C# application Pin
PDTUM20-Feb-14 5:54
PDTUM20-Feb-14 5:54 
QuestionRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 3:55
Nicholas Swandel21-Feb-14 3:55 
AnswerRe: Update Database for C# application Pin
PDTUM21-Feb-14 5:50
PDTUM21-Feb-14 5:50 
Thank you for your thoughts Nicholas. Truthfully, I am confused due to my lack of experience with "big" databases. Big is a relative term. What is Big? Perhaps some numbers might help. Lets say that there is a table called 'Orders' and it has 30 columns. Now lets say that it creates about 10 new rows every day per client. It must be able to retrieve 2 years worth of data in this table before it can be purged, or about 500 days. So that would be 5000 rows per client. Now, if it was a single database being shared by potentially 1000 users, that would make 5 million rows with 30 columns each for this table. Assuming that about 8 of the tables have this same amount of data, and the others are much smaller, the question is "is this big"? The problem is that I do not know. It seems big to me, but then again, I never understood how a major search engine can look through billions of entries in a matter of seconds either. To your statement that separate databases decrease performance, I would disagree with that in its entirety. On the other hand, I totally agree that Administration, which is what triggered the request for information in the first place, is definitely the issue of concern for me with individual databases. I suppose I could write an 'update' script to modify the database each time I update the program (a possible solution). I am at the point that I must go one way or the other. You raise some excellent points. Looking it over, perhaps a Hybrid choice is possible. Nothing says I cannot have 10 databases instead of 1000 which would limit the total users to 100 and decrease the data storage by 90 percent. Perhaps? The question is...Is that Enough? At how many users do I stop and make another database...10, 50, 100? I will keep researching and considering expertise from developers like yourself, for which I am grateful. If you have any followup thoughts, or can shed some light for me on the numbers game, please feel free to write me either here or privately. I appreciate your time and expertise. Thank you again. Best Regards, Pat
GeneralRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 6:20
Nicholas Swandel21-Feb-14 6:20 
Questionbegin tran in sql server 2008 Pin
vkEE19-Feb-14 5:22
vkEE19-Feb-14 5:22 
AnswerRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 6:02
professionalGuyThiebaut19-Feb-14 6:02 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 6:13
vkEE19-Feb-14 6:13 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 6:27
professionalGuyThiebaut19-Feb-14 6:27 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 6:43
vkEE19-Feb-14 6:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:32
professionalGuyThiebaut19-Feb-14 7:32 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:25
vkEE19-Feb-14 8:25 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:43
professionalGuyThiebaut19-Feb-14 8:43 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:52
professionalEddy Vluggen19-Feb-14 8:52 
GeneralRe: begin tran in sql server 2008 Pin
Ananth A21-Feb-14 0:43
Ananth A21-Feb-14 0:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut21-Feb-14 0:56
professionalGuyThiebaut21-Feb-14 0:56 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:25
professionalEddy Vluggen19-Feb-14 8:25 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:30
vkEE19-Feb-14 8:30 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:47
professionalGuyThiebaut19-Feb-14 8:47 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:59
vkEE19-Feb-14 8:59 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 10:26
professionalGuyThiebaut19-Feb-14 10:26 

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.