Click here to Skip to main content
11,567,325 members (49,985 online)
   

Database

 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 8:24
memberJörgen Andersson11-Oct-12 8:24 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 10:09
memberEddy Vluggen11-Oct-12 10:09 
AnswerRe: Global Database Design for example to store Addresses Pin
jschell11-Oct-12 9:20
memberjschell11-Oct-12 9:20 
AnswerTHX: Global Database Design for example to store Addresses Pin
LiQuick12-Oct-12 4:21
memberLiQuick12-Oct-12 4:21 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 5:37
memberEddy Vluggen12-Oct-12 5:37 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 8:15
memberJörgen Andersson12-Oct-12 8:15 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 10:54
memberEddy Vluggen12-Oct-12 10:54 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 11:34
memberJörgen Andersson12-Oct-12 11:34 
Well, I've had to clean out faulty data to many times because the software wasn't, and the communication didn't happen. So the human interaction entered data that shouldn't have been.

Clean unduplicated data is the main reason to normalize, performance is a positive sideeffect. But you lose time during development, that's for sure.
Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 13:38
memberEddy Vluggen12-Oct-12 13:38 
QuestionGet Filename and import fixed width file Pin
ReallyDumbDudee10-Oct-12 10:15
memberReallyDumbDudee10-Oct-12 10:15 
AnswerRe: Get Filename and import fixed width file Pin
Eddy Vluggen11-Oct-12 12:51
memberEddy Vluggen11-Oct-12 12:51 
QuestionRe: Get Filename and import fixed width file Pin
ReallyDumbDudee11-Oct-12 13:56
memberReallyDumbDudee11-Oct-12 13:56 
AnswerRe: Get Filename and import fixed width file Pin
Eddy Vluggen12-Oct-12 1:04
memberEddy Vluggen12-Oct-12 1:04 
Answer. Pin
SQL Ed10-Oct-12 8:21
memberSQL Ed10-Oct-12 8:21 
AnswerRe: tried to use a case when inside a WHERE clause but did not work. Need more efficient way to cover all IF ELSE scenarios. Pin
Eddy Vluggen10-Oct-12 9:26
memberEddy Vluggen10-Oct-12 9:26 
GeneralRe: tried to use a case when inside a WHERE clause but did not work. Need more efficient way to cover all IF ELSE scenarios. Pin
SQL Ed10-Oct-12 13:15
memberSQL Ed10-Oct-12 13:15 
GeneralRe: tried to use a case when inside a WHERE clause but did not work. Need more efficient way to cover all IF ELSE scenarios. Pin
mark merrens10-Oct-12 13:28
membermark merrens10-Oct-12 13:28 
GeneralRe: tried to use a case when inside a WHERE clause but did not work. Need more efficient way to cover all IF ELSE scenarios. Pin
Jörgen Andersson10-Oct-12 22:26
memberJörgen Andersson10-Oct-12 22:26 
GeneralRe: tried to use a case when inside a WHERE clause but did not work. Need more efficient way to cover all IF ELSE scenarios. Pin
Shameel11-Oct-12 0:27
memberShameel11-Oct-12 0:27 
GeneralRe: tried to use a case when inside a WHERE clause but did not work. Need more efficient way to cover all IF ELSE scenarios. Pin
Eddy Vluggen11-Oct-12 0:35
memberEddy Vluggen11-Oct-12 0:35 
QuestionHow to retrieve client IP address from sql server database Pin
Tridip Bhattacharjee9-Oct-12 20:53
memberTridip Bhattacharjee9-Oct-12 20:53 
AnswerRe: How to retrieve client IP address from sql server database Pin
digimanus10-Oct-12 1:20
memberdigimanus10-Oct-12 1:20 
QuestionMySQL code- Problems with cade when inside a WHERE clause Pin
SQL Ed9-Oct-12 11:31
memberSQL Ed9-Oct-12 11:31 
AnswerRe: MySQL code- Problems with cade when inside a WHERE clause Pin
Jörgen Andersson9-Oct-12 11:47
memberJörgen Andersson9-Oct-12 11:47 
QuestionDatabase connectivity failure when using ODBC Pin
bharath_ben9-Oct-12 3:16
memberbharath_ben9-Oct-12 3:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web03 | 2.8.150624.2 | Last Updated 29 Jun 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid