Click here to Skip to main content
15,887,350 members
Home / Discussions / Database
   

Database

 
QuestionSQLBulkCopy with ODBC Pin
Member 251595529-Oct-08 20:00
Member 251595529-Oct-08 20:00 
AnswerRe: SQLBulkCopy with ODBC Pin
Wendelius30-Oct-08 8:10
mentorWendelius30-Oct-08 8:10 
QuestionExtract number from string Pin
kyi kyi29-Oct-08 15:36
kyi kyi29-Oct-08 15:36 
AnswerRe: Extract number from string Pin
Meysam Mahfouzi29-Oct-08 17:26
Meysam Mahfouzi29-Oct-08 17:26 
GeneralRe: Extract number from string Pin
kyi kyi29-Oct-08 18:06
kyi kyi29-Oct-08 18:06 
GeneralRe: Extract number from string Pin
Meysam Mahfouzi29-Oct-08 20:02
Meysam Mahfouzi29-Oct-08 20:02 
QuestionUsing SQL as categorized tagging backend Pin
jchalfant29-Oct-08 4:36
jchalfant29-Oct-08 4:36 
AnswerRe: Using SQL as categorized tagging backend Pin
Wendelius29-Oct-08 8:12
mentorWendelius29-Oct-08 8:12 
The first one is definitely better.

You have far more options to tune the statements if you encounter bottlenecks when you have done database modelling as it should be done. The second one leads to several problems. Slow queries, poor maintainability, non-efficient indexing etc.

Just to throw another possibility, you could also consider xml-field on the same table as document names. It can be easily updated, using at client side is typically very straightforward and also it can be indexed.

Hope this helps,

Mika

The need to optimize rises from a bad design.

My articles[^]

GeneralRe: Using SQL as categorized tagging backend Pin
jchalfant29-Oct-08 8:37
jchalfant29-Oct-08 8:37 
GeneralRe: Using SQL as categorized tagging backend Pin
Wendelius29-Oct-08 8:53
mentorWendelius29-Oct-08 8:53 
AnswerRe: Using SQL as categorized tagging backend Pin
Ashfield29-Oct-08 9:53
Ashfield29-Oct-08 9:53 
GeneralRe: Using SQL as categorized tagging backend Pin
Wendelius3-Nov-08 9:19
mentorWendelius3-Nov-08 9:19 
QuestionAlternative to SOUNDEX? Pin
Richard Jones29-Oct-08 3:54
Richard Jones29-Oct-08 3:54 
AnswerRe: Alternative to SOUNDEX? Pin
Wendelius29-Oct-08 8:05
mentorWendelius29-Oct-08 8:05 
GeneralRe: Alternative to SOUNDEX? Pin
Richard Jones29-Oct-08 9:15
Richard Jones29-Oct-08 9:15 
GeneralRe: Alternative to SOUNDEX? Pin
Wendelius29-Oct-08 9:36
mentorWendelius29-Oct-08 9:36 
GeneralRe: Alternative to SOUNDEX? Pin
Richard Jones29-Oct-08 9:40
Richard Jones29-Oct-08 9:40 
GeneralRe: Alternative to SOUNDEX? Pin
ChandraRam30-Oct-08 1:23
ChandraRam30-Oct-08 1:23 
QuestionSSIS - Multiple packages using the same sharepoint path Pin
notes4we29-Oct-08 3:03
notes4we29-Oct-08 3:03 
Questionhow to get in report watermark text Pin
imranafsari28-Oct-08 23:56
imranafsari28-Oct-08 23:56 
QuestionEmbedded Fire Bird - Programmatically creating a new database [solved] Pin
Harvey Saayman28-Oct-08 23:54
Harvey Saayman28-Oct-08 23:54 
Questionincrement number Pin
susanhalim28-Oct-08 21:35
susanhalim28-Oct-08 21:35 
AnswerRe: increment number Pin
notes4we29-Oct-08 3:09
notes4we29-Oct-08 3:09 
AnswerRe: increment number Pin
PIEBALDconsult29-Oct-08 5:05
mvePIEBALDconsult29-Oct-08 5:05 
AnswerRe: increment number Pin
mahsa shahi1-Mar-14 7:09
mahsa shahi1-Mar-14 7:09 

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.