2,480 reputation
69
bio website systemajik.com
location Gatineau, Canada
age 59
visits member for 3 years, 10 months
seen 2 days ago
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.

Dec
1
answered How do I call a collection of tables with normalized (generic) information
Nov
29
comment If a database is in memory does it still need indexing?
If the query has an explicit or implicit limit, it may not need to scan the whole table. If a cursor is being used, it will stop scanning when it matches a row and resume scanning when the next row is requested.
Nov
28
revised Creating Triggers to insert into a table where the table is altered by other application
Add example and reference to documentation.
Nov
27
answered Creating Triggers to insert into a table where the table is altered by other application
Nov
17
answered SQL Performance: COUNT or extra attribute?
Nov
8
answered How can I quantify the business value of normalization?
Oct
30
answered Preventing duplicate data when usual normalization only makes sense for some of the records
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