Click here to Skip to main content
12,892,596 members (45,590 online)
   

Database

 
QuestionNeed help with a tricky MS SQL Query Pin
muya mwansa27-Nov-12 6:46
membermuya mwansa27-Nov-12 6:46 
AnswerRe: Need help with a tricky MS SQL Query Pin
Eddy Vluggen27-Nov-12 13:31
memberEddy Vluggen27-Nov-12 13:31 
GeneralRe: Need help with a tricky MS SQL Query Pin
jschell28-Nov-12 8:43
memberjschell28-Nov-12 8:43 
AnswerRe: Need help with a tricky MS SQL Query Pin
Deepak Kumar1128-Nov-12 1:03
memberDeepak Kumar1128-Nov-12 1:03 
QuestionBest Approach For Designing Database Pin
AmbiguousName27-Nov-12 3:59
memberAmbiguousName27-Nov-12 3:59 
AnswerRe: Best Approach For Designing Database Pin
jschell27-Nov-12 13:13
memberjschell27-Nov-12 13:13 
AnswerRe: Best Approach For Designing Database Pin
Mycroft Holmes27-Nov-12 13:14
memberMycroft Holmes27-Nov-12 13:14 
AnswerRe: Best Approach For Designing Database Pin
Eddy Vluggen27-Nov-12 13:23
memberEddy Vluggen27-Nov-12 13:23 
AmbiguousName wrote:
Can you please help me decide which way is better?

There is no "better" way; each has it's own advantages and disadvantages, and you'd need to check your requirements which suits better.

On a folder;

  • You can have clashes in naming. Filenames must be unique.
  • You have the advantage of the virusscanner picking things up. Most scanners don't do databases.
  • You track an external asset


In a database;

  • Easy with backups/restores; are you gonna backup that folder?
  • Centralized; no need to document outside-repositories
  • As easy to (hyper)link to as a document on a webserver. However, not being a file, the server cannot response to a header-request on it's freshness.

Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

AnswerRe: Best Approach For Designing Database Pin
Krishna Kumar Soni3-Dec-12 1:04
memberKrishna Kumar Soni3-Dec-12 1:04 
QuestionEXEC sp_helptext Pin
jojoba201126-Nov-12 22:43
memberjojoba201126-Nov-12 22:43 
AnswerRe: EXEC sp_helptext Pin
Mycroft Holmes26-Nov-12 23:30
memberMycroft Holmes26-Nov-12 23:30 
QuestionRe: EXEC sp_helptext Pin
jojoba201126-Nov-12 23:38
memberjojoba201126-Nov-12 23:38 
AnswerRe: EXEC sp_helptext Pin
djj5527-Nov-12 0:59
memberdjj5527-Nov-12 0:59 
QuestionRe: EXEC sp_helptext Pin
jojoba201127-Nov-12 3:09
memberjojoba201127-Nov-12 3:09 
AnswerRe: EXEC sp_helptext Pin
Eddy Vluggen27-Nov-12 13:33
memberEddy Vluggen27-Nov-12 13:33 
QuestionRECORD VALIDATION IN ACCESS Pin
teto26-Nov-12 5:19
memberteto26-Nov-12 5:19 
SuggestionRe: RECORD VALIDATION IN ACCESS Pin
André Kraak26-Nov-12 5:56
memberAndré Kraak26-Nov-12 5:56 
AnswerRe: RECORD VALIDATION IN ACCESS Pin
djj5526-Nov-12 6:05
memberdjj5526-Nov-12 6:05 
Questionhow to compare an operation in where expression In sql Pin
GREG_DORIANcod26-Nov-12 4:29
memberGREG_DORIANcod26-Nov-12 4:29 
AnswerRe: how to compare an operation in where expression In sql Pin
s_magus26-Nov-12 5:20
members_magus26-Nov-12 5:20 
AnswerRe: how to compare an operation in where expression In sql Pin
Mycroft Holmes26-Nov-12 11:56
memberMycroft Holmes26-Nov-12 11:56 
Questiongrant permission on table in another database Pin
Dan_K26-Nov-12 3:55
memberDan_K26-Nov-12 3:55 
QuestionRe: grant permission on table in another database Pin
Chris Meech26-Nov-12 8:25
memberChris Meech26-Nov-12 8:25 
QuestionHow to mearge local database with server database Pin
Jitendra Parida198723-Nov-12 22:00
memberJitendra Parida198723-Nov-12 22:00 
AnswerRe: How to mearge local database with server database Pin
Mycroft Holmes23-Nov-12 22:17
memberMycroft Holmes23-Nov-12 22:17 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 24 Apr 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid