Reputation
8,769
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 21 47
Newest
 Enlightened
Impact
~426k people reached

Jul
21
comment What is the best way to take backup for Remote DB Server
Please define what you exactly mean by backup here. Depending on the RDBMS, there might be several options, some are not doable via JDBC.
Jul
21
comment Database Noob: Transfer Data from Windows Server to Web Server Hosted Online
scp, sftp, remote bulk load and some less secure options.
Jul
21
comment DB design for employee working hours constraints
These decisions are usually a function of how much data (eg how many employees) you have, how (often) you access this data, how fast the response should be and so on. Building the availability table shouldn't be that difficult - why not try it yourself?
Jul
21
comment How can I optimize this Cross Table COUNT() mysql query?
Could you explain this a bit more? How can a missing GROUP BY lead to bad performance?
Jul
20
comment RMAN error RMAN-06207,RMAN-06208,RMAN-06210,RMAN-06211,RMAN-06212,RMAN-06213,RMAN-06214
The OP clearly tells us they tried this already.
Jul
17
comment How would I make this query run faster in postgres
I'm voting to close this question as off-topic because it is crossposted and has an answer on SO
Jul
17
comment Group or Order SQL output into a single row
Have you tried anything on your own? If not yet, look into the several questions tagged as pivot on this site.
Jul
17
comment Group or Order SQL output into a single row
How about the other commissions that may lie around?
Jul
17
comment How to suppress specific warnings in mysql error log when ignoring a table to replicate
You should add some flesh to your answer - like what you've stated in your comment.
Jul
17
comment MYSQL: Creating a table with same columns on remote machine
Why you don't simply connect to the remote DB from the local machine?
Jul
16
comment Grouping by sequential relationships with Postgres
@a_horse_with_no_name one can simply pick any node and find it's group, right?
Jul
16
comment Grouping by sequential relationships with Postgres
How do you find if a and b are related (member of the same group)? Alternatively, why is there a split between d and e?
Jul
16
comment Finding optimal indices, different query competing indices
I know it is no answer, but how do you squeeze 600 or 700 characters into a varchar(512)?
Jul
16
comment Having problems trying to back up a Postgres database from AWS RDS
Do you see this every time you start the dump?
Jul
16
comment MYSQL: Creating a table with same columns on remote machine
dev.mysql.com/doc/refman/5.7/en/show-create-table.html - first hit on Google for 'mysql get table definition'
Jul
15
comment Challenges with Key with Gaps?
@Hans-JürgenSchönig as the column is the PK, the problems would be prevented by the constraint. One has to handle the resulting error for sure :) Other than that, you are right - some sort of serialization (be it explicit locking and/or lookups to another table or else) is needed.
Jul
15
comment Challenges with Key with Gaps?
No, but show your (planned) index to get a real answer. BTW, your unique constraint does not make much sense as measuerment_id is already unique.
Jul
15
comment Challenges with Key with Gaps?
You simply should not rely on the order of an 'artificial' key (even the sequence can restart, if defined so). Furthermore, a serial is not supposed to be gapless - if you need this, you have to implement it somehow differently. As possibly the easiest way, you can reset the sequence to max(measurement_id) before each insert. Furthermore, you have a nice timestamp for ordering...
Jul
15
comment Display Total under name column and sum of amount under sal column
I think you are mixing here some concepts (namely how to write a query and how to display the results). However, you can easily construct a query with sum() and then UNION ALL it to the result of the main query.
Jul
15
comment SQL Server: Unable to save import export package, but am on Standard Edition
Isn't it so that your client tool is Express, and the limitation applies to it, not the database you connect to?