Reputation
4,443
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
5 15 31
Newest
 Caucus
Impact
~245k people reached

5h
comment Multi-core PostgreSQL server - how to improve performance
Back in the days when everything was "single-threaded" we used to have the maxim "add CPUs for concurrent users, add memory for performance".
Jul
31
comment Why would one need multiple instances of same Oracle database?
This doesn't answer the question. The question is about opening one database with multiple instances, ie RAC.
Jul
31
comment Why would one need multiple instances of same Oracle database?
This doesn't answer the question. The question is about opening one database with multiple instances, ie RAC.
Jul
30
comment Storing Large Nested Objects
JSON has better write speed. I'm guessing JSONB will have better read speed, but it should be very close. Why don't you test both and report back?
Jul
29
comment How to encrypt user passwords for forum registrations?
Shouldn't you be hashing the password+salt?
Jul
29
comment Select using a different value than id on join
Why is that not correct? What result is it giving? What result do you expect or want?
Jul
27
comment How to do superscript in SQL Server 2012 query?
Well, in theory you could use Unicode superscript characters.
Jul
24
comment Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
Yes, you can update views -- at least in most DBMSes.
Jul
24
comment Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
Can you rename the table(s) and replace the table(s) with view(s) that simply do select * from <underlyingtable> order by <column>?
Jul
23
comment Get rows changed between two dates (latest and previous)
in finds values in a set, not in between two values. For that you would need between <a> and <b> but that won't work with a subquery in this way.
Jul
23
comment Converting Legacy SQL Server 2005 Stored Procedure to Transaction based for parallelism
Without knowing your data, structures and code we can't really help you. Voting to close.
Jul
22
comment How do I convert a datetime column from SQL Server 2014 to Oracle 11g using ogr2ogr?
It seems to me that your problem stems from the fact that you are converting the datetime column to a string and then relying on the Oracle session's NLS settings to convert that string to an Oracle date. I'd check what your NLS settings are to see if it matches the format you are using in the date-stored-as-a-string.
Jul
21
comment Oracle ODBC Driver, Tables and Columns Remarks
I think you might be right, unfortunately.
Jul
21
comment Oracle ODBC Driver, Tables and Columns Remarks
Which platform are you on?
Jul
21
comment cannot delete db table
And the real take-home from all of this is: Don't delete .frm and .ibd files by hand.
Jul
21
comment Can I use OpenLDAP to authenticate users in Oracle?
Please don't create link-only answers.
Jul
19
comment SQL injection in Postgres functions vs prepared queries
possible duplicate of Do stored procedures prevent SQL injection?
Jul
17
comment Separate indices for the field I want to get the MAX() and the ones in the WHERE clause
I know PostgreSQL can. I've never tried it on Oracle though...
Jul
16
comment How should I design a specific needs mysql table
Do you have to build anything? This is the sort of thing I would normally do using Google Analytics, or in a bygone era myself using a HTTP log analyzer.
Jul
16
comment Set session query timeout
If you can create your own OCI calls, then you can do it, see stackoverflow.com/a/756157/391445