meta user
network profile
| bio | website | |
|---|---|---|
| location | Munich | |
| age | ||
| visits | member for | 2 years, 1 month |
| seen | 6 hours ago | |
| stats | profile views | 774 |
I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)
|
Jun 11 |
comment |
Convert the table PROCESSLIST from InnoDB to MYISAM Try to run your select in auto-commit mode, or end the transaction using a commit before running the select. Could be you are affected by MySQL's default isolation level REPEATABLE READ |
|
Jun 11 |
comment |
Convert the table PROCESSLIST from InnoDB to MYISAM And why would that require to change the storage engine? |
|
Jun 11 |
comment |
Convert the table PROCESSLIST from InnoDB to MYISAM Why would you want to do that in the first place? That sounds like a really weird thing to do. |
|
Jun 11 |
comment |
PostgreSQL: Executing DDL on every schema @RolandoMySQLDBA: Postgres instead of PostgreSQL is perfectly OK. |
|
Jun 11 |
comment |
What are the advantages of sequences in SQL Server 2012? @MartinSmith: true, however I think we could except some basic searching to be done before asking such a question. After all the tooltip for the downvote arrow starts with "The question does not show any research effort" which is clearly the case here. |
|
Jun 11 |
comment |
Is there a way, in a single SQL statement to ensure that all items in a list are present in some column? Please show us the table definition together with some sample data and expected output. |
|
Jun 11 |
comment |
What are the advantages of sequences in SQL Server 2012? A quick google search turns up this: stackoverflow.com/questions/10062328/sequence-vs-identity and this: sqlservergeeks.com/blogs/AhmadOsama/personal/624/… and this: sql-server-performance.com/2011/sequence-sql-server-2011 and this: sqlblog.com/blogs/john_paul_cook/archive/2013/01/01/… and this: sqlnotes.info/2011/11/18/sql-server-sequence-internal |
|
Jun 11 |
comment |
PostgreSQL “freeze”/“unfreeze” command equivalents @Dan: you can take a consistent snapshot using pg_dump without the need to block writes. |
|
Jun 10 |
comment |
PostgreSQL “freeze”/“unfreeze” command equivalents I think you are looking for pg_start_backup(): postgresql.org/docs/current/static/… But you should read this: postgresql.org/docs/current/static/backup-file.html to understand why you can't just take a filesystem backup while the server is running |
|
Jun 10 |
comment |
Find the salary difference between two months There is no need for the complicated self join. |
|
Jun 10 |
comment |
Does MySQL cache queries? "in common with all other popular database products": that is a bit misleading. Hardly any DBMS actively caches query results the way MySQL does. DBMS usually only cache table (or index) data, not query results. Most of them do cache the query exeution plan (and the query "source") |
|
Jun 10 |
comment |
Oracle: Lost significant part of foreign-keys I don't think you can get that information because Oracle doesn't keep such a history. |
|
Jun 10 |
comment |
Database design for different kinds of user profiles in SQL Server Cross posted: stackoverflow.com/q/17026706/330315 |
|
Jun 8 |
comment |
Want to Get Brands In Wordpress Database Structure Saved as Custom Post types Which DBMS are you using? Postgres? Oracle? |
|
Jun 7 |
comment |
Oracle remove and place (re-install) database on 10g Do you really want to drop "the database"? Note that a "database" in Oracle is basically the whole installation, not just a single "namespace" inside the system (as e.g. in Postgres or SQL Server). It seems you just want to drop the schema (=user). In that case, drop user ... cascade is the best option. |
|
Jun 7 |
comment |
Oracle remove and place (re-install) database on 10gimp is not a "SQLPlus" command. It's a commandline tool. |
|
Jun 6 |
comment |
pg_dump 9.2.x command does not work with pg_dump 9.2.3 Maybe there is an old pg_dump on the path. What does pg_dump --version show? |
|
Jun 5 |
comment |
IIS difference: Remove and Deploy -> Delete Site and Content There is no IIS tag for a reason: this has nothing to do with using or administering a relational database. |
|
Jun 5 |
comment |
Should date formats be specified in SQL statements? Localization settings of the DBMS (or the connection) have nothing to do with localizing the application. The Oracle JDBC driver for example initializes the NLS "environment" based on the language of your operating system and your regional settings. So one query might run on my computer but not on your computer regardless of the application that is using the database. |
|
Jun 5 |
comment |
How to import a text file with '|' delimited data to PostgreSQL database? Your header (and data) contains an "empty" column at the end, because it ends with two commas: ..EXPEDITEDREVIEW,, |
