I have a table design scenario and as a non-DBA type, would like opinions on which is more scaleable. Say you are asked to record information on houses for a metro area, starting with a small ...
SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
(Someone suggested I should ask this here too; previously posted on ...
In brief: I'm developing a database that handles GTFS datasets from multiple transit agencies. Each dataset contains millions of rows in the stop_times.txt file (and thus its corresponding table). ...