Reputation
12,532
Next tag badge:
733/1000 score
223/200 answers
Badges
7 32 59
Newest
 sql
Impact
~665k people reached

Mar
22
reviewed Close Should a TeamMembers table have a relationship with the Student Table or the Enrolment Table?
Mar
22
revised Constraint to prevent overlapping Time periods
added 10 characters in body
Mar
22
reviewed Reopen Backing up multiple databases to the same point in time
Mar
22
comment Moving slow sub-query to With clause
Please add the EXPLAIN (ANALYZE, BUFFERS) output of the slow query. Without it it is really like asking people to check their crystal balls. Mine is broken, for one.
Mar
22
revised Why is context_info sometimes blank in sys.dm_exec_sessions?
added 8 characters in body
Mar
22
awarded  Popular Question
Mar
22
revised Why is context_info sometimes blank in sys.dm_exec_sessions?
deleted 38 characters in body; edited title
Mar
21
comment Empty string values - PostgreSQL 9.2
Why, are you having hundreds of suspicious queries? To be clear, this problem of you can have uncountable sources, neither of those known to us.
Mar
21
comment Empty string values - PostgreSQL 9.2
Go to your code base, pick all queries that insert into this table or update its content, and then figure out which one is at fault.
Mar
20
revised Why isn't this PosgreSQL LIKE query working?
added 1 character in body
Mar
20
revised Select rows with most recent date for the given date
added 27 characters in body
Mar
19
revised Setting up PostgreSQL Connection with DBVisualiser
edited tags
Mar
19
revised Is it possible to allow missing value inserts in mysql instead of requiring “NULL” in the query?
added 19 characters in body
Mar
19
comment How can I export just the structure of a MySQL database?
How is this different from the other similar answer?
Mar
19
comment How can I export just the structure of a MySQL database?
Is this a different version of PhpMyAdmin than the one in the accepted answer?
Mar
19
revised How can I export just the structure of a MySQL database?
added 11 characters in body
Mar
19
revised How can I export just the structure of a MySQL database?
deleted 89 characters in body; edited tags; edited title
Mar
18
comment Does the PostgreSQL COPY command have the option of choosing with fields to map the CSV columns to?
@Patrick7 thanks, I've added this bit.
Mar
18
revised Does the PostgreSQL COPY command have the option of choosing with fields to map the CSV columns to?
added 288 characters in body
Mar
18
revised Create dynamic WHERE clause from a JSON field
added 589 characters in body