914 reputation
624
bio website basetable.wordpress.com
location Edinburgh, United Kingdom
age 26
visits member for 3 years, 4 months
seen 9 hours ago

Education is learning what you didn't even know you didn't know. - Daniel J Boorstin

On my day job I maintain a large database application for a growing Edinburgh-based travel search company. Every day I learn more about development and administration in the trenches, including how to cope with legacy worst practices and how to benefit from SQL Server best practices.

Studying part-time at Dundee University for an MSc in Business Intelligence.


Oct
26
awarded  Popular Question
Oct
21
awarded  Notable Question
Sep
9
awarded  Popular Question
Sep
5
awarded  Notable Question
Aug
25
awarded  Popular Question
Aug
23
awarded  Yearling
Jul
2
awarded  Curious
Jun
19
comment Normalization of Time Series Data
How are you measuring efficiency? Repitition of values is not necessarily a bad thing. In fact, in a column-oriented database, it's normal. A good engine will store value patterns efficiently.
Mar
29
awarded  Notable Question
Feb
6
awarded  Popular Question
Feb
5
awarded  Popular Question
Jan
11
revised How can I enforce ensure uniqueness of an association with a time dimension?
Explain query. Rearrange for clarity.
Jan
11
comment How can I enforce ensure uniqueness of an association with a time dimension?
@DavidBullock It's a useful reference, but Alexander Kuznetsov's solution requires a different table design. Is it strictly necessary?
Jan
11
answered How can I enforce ensure uniqueness of an association with a time dimension?
Jan
8
comment UPDATE a column by COUNT of another table
The join is ANSI-style, but the UPDATE as a whole is MySQL syntax. @ypercube Is it true that the only ANSI-compliant way to update one table from another is to use subqueries in the SET clause? It's horribly verbose.
Jan
8
comment Is it better to start with a smaller INT types and grow as needed?
It can be a lot of work to modify an existing schema, especially if the columns are referenced. By the time you realize that you need a bigger column, you might not have time to complete the modification work before the IDs would saturate. You could move old data to an archive table, but it's a nightmare to reconcile. Be warned!
Jan
6
comment Same table for real persons and fictional one
Can you tell us about the tables with foreign keys? Please show us a schema diagram, some table definitions, or some sample data. How do your applications use the real names? How do they use the fictional names?
Jan
6
awarded  Tumbleweed
Jan
6
comment Method to keep track of large number of sets with high cardinality
OP mentioned PostgreSQL and not SQL Server. Not sure how much of this is applicable in a PostgreSQL environment.
Jan
6
comment Find the highest graded student, using Tuple Relational Calculus
@ThomasKejser Could be part course in relational data management? Erwin Smout apparently meets a lot of people who are tasked with converting between SQL and more theorical notation.