884 reputation
321
bio website basetable.wordpress.com
location Edinburgh, United Kingdom
age 26
visits member for 2 years, 11 months
seen Jul 22 at 15:31

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.


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.
Jan
6
comment Mysql - Change name of Information_schema
Your latest edit (how to avoid SQL injection?) is a whole new question. Ask it seperately to get a better answer. Short answer: use prepared statements and parameterized queries.
Jan
6
answered how to dump MS-SQL DB using PHP with MS-SQL-SRV.?
Jan
6
comment how to dump MS-SQL DB using PHP with MS-SQL-SRV.?
I think your interpretation might be correct. I read "dump" as "backup" because in MySQL they are basically the same thing.
Jan
5
comment how to dump MS-SQL DB using PHP with MS-SQL-SRV.?
At a simple level, the backup process is the same. Each backup process creates a file with a static copy of the database structure and data. You can use this file to restore the database at another time or in another place. The main basic difference is you can't open a SQL Server backup in Notepad and understand the content. With PHP's exec and sqlcmd on the path you can do anything you could do in T-SQL.
Jan
5
comment how to dump MS-SQL DB using PHP with MS-SQL-SRV.?
Can you clarify whether you want to backup the whole database, or just one table? The solution in each scenario is quite different. There is no simple equivalent of the mysqldump utility.
Jan
5
comment Best practices for handling language
@PeterKindberg Glad this helped you. A small thing: The column names are confusing if you follow the ISO terminology. ISO Language codes are lower 2-char (en), country codes are upper 2-char (US), culture codes are "language-country" codes (en-US).