Click here to Skip to main content
14,028,233 members
   

Database

 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 11:59
protectorPIEBALDconsult29-Jan-13 11:59 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 12:09
memberMycroft Holmes29-Jan-13 12:09 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 12:17
membermrfalk29-Jan-13 12:17 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:27
protectorPIEBALDconsult29-Jan-13 12:27 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:49
memberMycroft Holmes29-Jan-13 13:49 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:20
protectorPIEBALDconsult29-Jan-13 12:20 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:54
memberMycroft Holmes29-Jan-13 13:54 
GeneralRe: SQL Update Pin
jschell29-Jan-13 14:13
memberjschell29-Jan-13 14:13 
PIEBALDconsult wrote:
Perfect practice makes perfect. Do it the right way every time.


Nope. Not in the real world.

The real world is about money. Getting it perfect every time takes time and thus costs money. In the real world it isn't possible to get it perfect and most of the time it will not have any significant impact on actual required production functionality. Thus the extra cost is lost revenue which will never be regained.

This of course isn't the same as saying that one can write poor code all the time. But rather one must learn to recognize that ones time is in fact valuable and thus one must prioritize what one spends time on. And since, again in the real world, one can not spend an infinite amount of time on everything, one must make compromises.

And one might specifically look at this thread as an example and note that without knowing about the actual business of which this artifact is a part one will not have any idea about specifics such as size of the table, usage statistics, allowed maintenance, etc. And when one looks at all possible tables in all possible businesses, on average it won't matter.

PIEBALDconsult wrote:
I see too much bad SQL being written. It should be nipped in its bud.


Myself I see a lot of average code being written - it isn't specific to any language. Which is quite comforting since otherwise humans wouldn't be the ones writing it. If you are seeing a lot of poor SQL then maybe you need to start looking at a broader range of sources.
GeneralRe: SQL Update Pin
Michael Potter30-Jan-13 4:28
memberMichael Potter30-Jan-13 4:28 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 5:05
protectorPIEBALDconsult30-Jan-13 5:05 
GeneralRe: SQL Update Pin
jschell30-Jan-13 7:58
memberjschell30-Jan-13 7:58 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 8:40
protectorPIEBALDconsult30-Jan-13 8:40 
GeneralRe: SQL Update Pin
Michael Potter31-Jan-13 3:57
memberMichael Potter31-Jan-13 3:57 
GeneralRe: SQL Update Pin
PIEBALDconsult31-Jan-13 4:05
protectorPIEBALDconsult31-Jan-13 4:05 
GeneralRe: SQL Update Pin
jschell31-Jan-13 8:01
memberjschell31-Jan-13 8:01 
AnswerRe: SQL Update Pin
PIEBALDconsult29-Jan-13 13:22
protectorPIEBALDconsult29-Jan-13 13:22 
AnswerRe: SQL Update Pin
Jörgen Andersson30-Jan-13 1:21
protectorJörgen Andersson30-Jan-13 1:21 
AnswerRe: SQL Update Pin
mrfalk30-Jan-13 6:20
membermrfalk30-Jan-13 6:20 
QuestionDatabase backup size Pin
savbace28-Jan-13 22:45
membersavbace28-Jan-13 22:45 
AnswerRe: Database backup size Pin
Richard Deeming29-Jan-13 1:21
mveRichard Deeming29-Jan-13 1:21 
QuestionSQL Server 2005 Express running slow ? Pin
Member 245846728-Jan-13 15:56
memberMember 245846728-Jan-13 15:56 
AnswerRe: SQL Server 2005 Express running slow ? Pin
PIEBALDconsult28-Jan-13 16:11
protectorPIEBALDconsult28-Jan-13 16:11 
AnswerRe: SQL Server 2005 Express running slow ? Pin
Mycroft Holmes28-Jan-13 17:02
memberMycroft Holmes28-Jan-13 17:02 
AnswerRe: SQL Server 2005 Express running slow ? Pin
JOAT-MON29-Jan-13 11:09
memberJOAT-MON29-Jan-13 11:09 
QuestionCombining Data From Temp Tables Pin
Matt U.28-Jan-13 8:46
memberMatt U.28-Jan-13 8:46 

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 | Cookies | Terms of Service
Web06 | 2.8.190419.4 | Last Updated 18 Apr 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid