2,405 reputation
69
bio website systemajik.com
location Gatineau, Canada
age 59
visits member for 3 years, 8 months
seen yesterday
I have over 30 years experience in all phases of software development and delivery. I have administered a variety of midrange servers, and worked with systems from PCs to Mainframes.

Oct
19
answered Fourth inner join to the same table increases query duration significantly
Oct
2
comment Supertyping Inventory Transactions
@N.Balauro It can be that simple. I've updated my response with some additional columns
Oct
2
revised Supertyping Inventory Transactions
Add more details.
Sep
30
answered Supertyping Inventory Transactions
Sep
20
revised Postgres primary key sorted in the reverse order. Will it use the index efficiently?
Fix typo
Sep
6
answered comparing values between two tables
Jul
12
answered Large NOT IN Statement vs Creating/Populating Temp Table
Jun
10
revised Does 3NF require 2NF?
deleted 3 characters in body
Jun
7
comment Best way to store country and city information
@BTestQ As long as you don't need to disambiguate multiple cities in the same country, you can use a Cities table. See: en.wikipedia.org/wiki/Paris_%28USA%29 for a list of states with Paris in them. If you allow users to enter cities you are likely to end up with Parsi, paris, Paris, and other variations. If you don't, you will get bogus data.
Jun
6
comment Best way to store country and city information
@BTestQ I have updated my response. City tables are difficult to work with. You will need to determine your requirements. The timezone data provides a large city for each country. Stick with querying messages until you find it is too slow. (Use an index.)
Jun
6
revised Best way to store country and city information
Respond to comment.
Jun
5
answered Best way to store country and city information
May
6
answered Shared emails in a database
May
4
comment What is better in IN()? Sub-query or list of values
@stix As you gain experience, you will likely found the EXISTS option works well for certain queries. I find it works best when the result set without the extra table is smaller then the number of entries matching in the extra table. In other cases, you may find it slower than one of the options provided.
Apr
28
revised Does 3NF require 2NF?
added 305 characters in body
Apr
28
answered Does 3NF require 2NF?
Apr
27
answered Decomposing into 2NF
Apr
16
answered Create one-to-many to two fields in different table
Apr
14
answered Table join inheritance
Apr
4
revised Database Normalization: A Case Of The NULLs
Clarify