Hard Coded Values

Often we see code with business logic in the form of hard coded values. For example, a long, comma separated IN statement which lists out a category. These comma delimited lists are of course data duplication, nothing anyone wants. It would be worth the time to create views for these business definitions and use the views repeatedly. Functions are tricky because of their potential for great impact on performance. Tables which have multiple categories grouped by a parent id which self joins are also useful. Or dedicated tables too.

This entry was posted in DBA, SQL. Bookmark the permalink.

2 Responses to Hard Coded Values

  1. Dejan says:

    What i don’t understood is in truth how you’re now not rellay much more smartly-favored than you might be right now. You are very intelligent. You already know therefore considerably in terms of this topic, made me individually believe it from numerous numerous angles. Its like men and women are not fascinated unless it’s something to accomplish with Girl gaga! Your personal stuffs outstanding. Always deal with it up!

Leave a Reply

Your email address will not be published. Required fields are marked *