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

Database

 
QuestionService Account Pin
Satish Pai1-Jun-09 18:50
Satish Pai1-Jun-09 18:50 
AnswerRe: Service Account Pin
Niladri_Biswas7-Jun-09 0:12
Niladri_Biswas7-Jun-09 0:12 
QuestionWhere to store my files? Pin
musefan1-Jun-09 4:04
musefan1-Jun-09 4:04 
AnswerRe: Where to store my files? Pin
David Mujica1-Jun-09 4:28
David Mujica1-Jun-09 4:28 
GeneralRe: Where to store my files? Pin
musefan1-Jun-09 4:36
musefan1-Jun-09 4:36 
GeneralGo with storing files on fileserver Pin
David Mujica1-Jun-09 5:29
David Mujica1-Jun-09 5:29 
GeneralRe: Go with storing files on fileserver Pin
musefan1-Jun-09 5:46
musefan1-Jun-09 5:46 
AnswerRe: Where to store my files? Pin
Eddy Vluggen1-Jun-09 5:05
professionalEddy Vluggen1-Jun-09 5:05 
musefan wrote:
found a number of sources that basically agree on one thing - Databases are good for small files ( < 256KB) where as file systems are better for files larger than this.


Sounds like a rule of thumb gone mad. It would be crazy to store ISO-files in a database, I'll agree to that. There is no limit in size to determine whether or not to store data in a database; it's more appropriate to consider the type of data and it's usage.

There are various pro's and con's for both;

Pro Filesystem
* Simpler maintenance (manipulating files through Windows' Explorer is easier then SQL)
* Auto-integration into your Google Desktop Search / Whatever filesystem-indexer.

Against Filesystem
* Harder maintenance (filesystem rights, networking issues etc)

Pro Database
* Full-text search available, as well as an easy option for replication
* Ability to add auditing easily, as well as file-comments, tags etc.

Against Database
* Files aren't linked to the Active Directory
* GDS/Windows Indexing Service doesn't look "inside" the database to index your files

For both options; don't forget to add a backup-strategy.

I are troll Smile | :)

GeneralRe: Where to store my files? Pin
musefan1-Jun-09 5:13
musefan1-Jun-09 5:13 
GeneralRe: Where to store my files? Pin
Eddy Vluggen1-Jun-09 7:57
professionalEddy Vluggen1-Jun-09 7:57 
QuestionVFP OLE DB Provider error: Variable X is not found Pin
dasha_pl1-Jun-09 3:35
dasha_pl1-Jun-09 3:35 
QuestionSQL 2008 Workgroup - how do CALs work? Pin
aastudent1-Jun-09 0:38
aastudent1-Jun-09 0:38 
AnswerRe: SQL 2008 Workgroup - how do CALs work? Pin
Mycroft Holmes1-Jun-09 1:14
professionalMycroft Holmes1-Jun-09 1:14 
GeneralRe: SQL 2008 Workgroup - how do CALs work? Pin
aastudent1-Jun-09 1:26
aastudent1-Jun-09 1:26 
Questionproblem in executing stored procedure Pin
souravghosh1831-May-09 20:12
souravghosh1831-May-09 20:12 
AnswerRe: problem in executing stored procedure Pin
Aman Bhullar6-Jun-09 1:50
Aman Bhullar6-Jun-09 1:50 
AnswerRe: problem in executing stored procedure Pin
Niladri_Biswas25-Jun-09 5:57
Niladri_Biswas25-Jun-09 5:57 
QuestionCONTAINS not working in my full text search Pin
Brendan Vogt31-May-09 5:13
Brendan Vogt31-May-09 5:13 
AnswerRe: CONTAINS not working in my full text search Pin
Satish Pai31-May-09 19:49
Satish Pai31-May-09 19:49 
Questionline break not working in crystal reports ? Pin
kindman_nb30-May-09 21:58
kindman_nb30-May-09 21:58 
AnswerRe: line break not working in crystal reports ? Pin
Rajesh Anuhya1-Jun-09 0:03
professionalRajesh Anuhya1-Jun-09 0:03 
QuestionHelp with SQL query Pin
Joe_P30-May-09 10:30
Joe_P30-May-09 10:30 
AnswerRe: Help with SQL query Pin
Mycroft Holmes30-May-09 23:06
professionalMycroft Holmes30-May-09 23:06 
GeneralRe: Help with SQL query Pin
Joe_P31-May-09 4:11
Joe_P31-May-09 4:11 
GeneralRe: Help with SQL query Pin
Mycroft Holmes31-May-09 11:10
professionalMycroft Holmes31-May-09 11:10 

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.