Reputation
15,364
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 58
Newest
 Caucus
Impact
~986k people reached

Jul
14
comment SELECT in trigger function in two tables
Show us the definition of the ins_function()
Jul
14
comment Metaphone / Soundex Dictionary
Which DBMS are you using? Postgres? Oracle?
Jul
13
comment Efficient structure for querying membership in many-to-many relationship where tableA has ONLY the indicated members from tableB?
Please show us the create table statement for the tags table.
Jul
13
comment Do multiple SQL Server instances increase security?
I don't think multiple instances would increase security. It could decrease vulnerability though - because if one server is hacked, the damage is limited to that server. But then: if there is a security hole, it's most likely that the other servers will be hacked as well.
Jul
10
comment Using a GIN index on an integer array to model sets of tags
databasesoup.com/2015/01/tag-all-things.html
Jul
10
comment To have PostgreSQL-like Partial Index in MySQL 5.5
@Masi: if the advanced features of Postgres do help to achieve what you want/need, then why shouldn't you be able to install Postgres? Cern/Scientific Linux is based on RedHat if I'm not mistaken, so Postgres should run just fine there.
Jul
10
comment GRANT USAGE on all schemas in a database? postgres
I wonder if you could simulate default privileges for newly created schemas by using an event trigger that automatically runs the grant usage for the new schema.
Jul
9
comment Slow window function query with big table
Most probably unrelated, but why do you use a RC1 if there are already 4 bugfix release for 9.4?
Jul
9
comment Update one column based on count of records of grouped value in another column
Which DBMS are you using? Postgres? Oracle?
Jul
9
comment Get 10th and 90th percentile by customer
Can you add the expected output based on the sample data?
Jul
9
comment How to find similar (but different) names with the same soundex value?
And please do not post SQL statements as screen shots. Show the statements as formatted text.
Jul
9
comment Cann't connect from another server to Oracle
@miracle173: of course hostname needs to resolve to the alias defined in tnsnames.ora. From the manual "You must enter (...) a net service name to connect to a database". If lsnrctl status doesn't show the service than this does indicate the instance didn't register.
Jul
9
comment Cann't connect from another server to Oracle
Looks like your instance didn't register with the listener. What happens if you connect locally and run alter system register. Also what does tnsping hostname give you? Are you aware that you the "hostname" part isn't really a "hostname" but a "TNS name" - as defined in tnsnames.ora
Jul
8
comment ANY in postgresql gives weird error
see: stackoverflow.com/a/31292583/330315
Jul
8
comment Error while restoring Postgres DB Dump
Not really proficient in Linux shell, but shouldn't that be gunzip -c my_db_dump.sql.gz | psql ...?
Jul
8
comment Firebird-Time Interval- between 2 Dates
Although a correct answer, it's probably better if you include a complete SQL statement that can be executed directly rather than just a code fragment.
Jul
8
comment Split field values using specific character
Which DBMS are you using? Postgres? Oracle?
Jul
7
comment How to partition existing table in postgres?
Nice writeup. It would be interesting if that actually makes your queries faster. 10 million still isn't that many rows that I would think about partitioning. I wonder if your degrading performance was maybe caused with vacuum not catching up or being prevented due to "idle in transaction" sessions.
Jul
7
comment How to print to console in SQL?
Cross post: stackoverflow.com/questions/31260497/…
Jul
7
comment How to print to console in SQL?
There is no equivalent top raisein plain SQL