Reputation
15,617
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 54
Impact
~1.3m people reached

May
7
reviewed Close Is there an easy way to update a mysqldump file from version 9.11 to 10.11?
May
7
reviewed Close I want to pivot a table and aggregate a column into strings
May
7
revised Help with PIVOT query
Tag
May
7
reviewed Leave Open I want to make a new column based on another column
May
7
reviewed Reopen Replace value using several criteria in another table
May
7
reviewed No Action Needed Can I log which stored procedure issued a delete statement?
May
7
revised I want to make a new column based on another column
edited tags
May
7
revised I want to make a new column based on another column
added 385 characters in body
May
7
answered I want to make a new column based on another column
May
7
reviewed Approve Hibernate Query Running Slow
May
7
reviewed Close Hiding server folders for specific user in SQL Server Management Studio
May
7
reviewed Reviewed App domain is marked for unload due to memory pressure
May
7
reviewed Reviewed Challenged with modeling a big DB
May
7
comment Challenged with modeling a big DB
Any RDBMS, given a correctly designed data model, can do this these days. The volumes you're talking about are not by any means gigantic. Oracle, Postgres, SQL Server would all do what you require with ease. I can't comment on NoSQL approaches.
May
7
comment Critical tablespace usage UNDOTBS (96%)
Yes, you can do it while the DB is up
May
7
comment Selecting different values from different columns
Why isn't the first queues='ACS' row selected (24-02-2014) instead of the 2nd one? Do you mean you want the newest ACS row as min and newest GHK as Max timestamp, for the same group name? You're going to have to explain the logic better, as it stands it isn't answerable
May
7
reviewed No Action Needed Replace value using several criteria in another table
May
6
reviewed No Action Needed Listener.ora problem when I copy OVA
May
6
reviewed Close Why MySQL SELECT performance depends on table size?
May
6
reviewed Approve UPDATE a column by COUNT of another table