Reputation
19,793
Next tag badge:
91/100 score
20/20 answers
Badges
6 55 104
Impact
~2.4m people reached

Dec
13
comment MySQL replication seems to work but no data is transferred
@Rick he did, but are you suggesting the question should be re-opened? Because it's a typo, I think it is "…unlikely to help other users…" (see the close reason above). That doesn't mean we shouldn't help the OP and it's good he got an answer, it just means we don't want the question to rank on Google (it won't disappear with an up-voted accepted answer).
Dec
10
revised Return the lowest value
having the RDBMS in the tag is the best place for it — no need to have it in the body of the question too.
Dec
7
revised How do I fix an Orphaned User in Log Shipped version of a SQL Server 2008 database
added 993 characters in body
Dec
7
comment Restoring differential backup creates DEFUNCT log file?
FilamentUnities if the comment above is correct, please update your answer
Dec
2
awarded  Good Answer
Dec
1
revised Copying (hundreds of) tables from one server to another (with SSMS)
edited tags
Nov
30
comment MySQL replication seems to work but no data is transferred
Please flag for re-opening if it turns out that the "records;" typo is not the issue.
Nov
30
comment MySQL replication seems to work but no data is transferred
When you say "You don't need that extra semi-colon", are you suggesting that it is the cause of the problem?
Nov
29
revised Can I install SQL Server Management Studio locally?
edited tags
Nov
25
revised Restrict Postgres roles by IP address outside of the pg_hba.conf file
inlined code — much easier to see it here than to have to visit an external link
Nov
25
comment mysql not using index on production query, yet does on staging and local
@3manuek thanks for contributing, I've changed it into a comment for you. I hope you stick around for more Q&A — getting enough rep to comment is a very low bar.
Nov
23
awarded  Good Question
Nov
21
revised Why MySQL is still “using temporary” when update by primary key?
edited tags
Nov
19
comment “ERROR: there is no parameter $1” in “EXECUTE .. USING ..;” statement in plpgsql
@Erwin reopened :)
Nov
18
comment PostgreSQL: labels vs columns
depends — if you mean you are seperately querying on date then you want a seperate index, if you mean you are quering like select baz from my_table where date=X and foo=1 then you might want date in the same index.
Nov
18
comment PostgreSQL: labels vs columns
but please please don't use date and value as your actual column names of course!
Nov
18
comment PostgreSQL: labels vs columns
If your queries are of the form select baz from my_table where foo=1 then an index on foo,baz would be appropriate. Your other design might have an index on foo,label,value. Query would be something like select value baz from my_table where foo=1 and label='baz'.
Nov
18
comment PostgreSQL: labels vs columns
It may well make no difference how large the datasets are if they are indexed properly (eg take a look at covering indexes: en.wikipedia.org/wiki/Database_index#Covering_index)
Nov
18
comment PostgreSQL: labels vs columns
"While the latter is better normalized" is it? Only if at least one of bar, baz and boo can be null, is that actually the case? "finding all baz values when foo = 1" is likely going to be fast enough either way if you index foo/value.
Nov
18
revised Difference between database vs user vs schema
tweaked to emphasise that this is a common way of using the terms, not just made up.