11,163 reputation
11842
bio website
location Munich
age
visits member for 3 years, 2 months
seen 5 mins ago

Jul
1
comment getting “table is full” error even if the table size is much smaller than tablespace
"a varchar(100) variable will reserve all the space like you have 100 characters in all rows of the column" - is that a special "feature" of NDBCLUSTER? Because InnoDB (or MyISAM) don't do that. It would be true for char(100) though.
Jul
1
comment How do I stop views (large data sets) from freezing my database
What exactly do you mean with "commands to refresh views"? A view doesn't need a "refresh" the data in there is always "up-to-date".
Jun
30
comment Is select * still a big no-no on SQL Server 2012?
I consider select * bad coding style in any DBMS not just SQL Server.
Jun
30
comment JDBC , make connection static to improve performance
You should use a connection pool (and btw: JDBC is not "slow")
Jun
28
comment Restore an oracle dmp file
Are you sure the dump was taken using is a legacy tool exp. Could it be a dump taken using DataPump (expdp)? In that case you need to use impdp to import it. And imp doesn't "create folders" - so it's totally unclear what you are doing
Jun
28
comment What is the “other miscellaneous information” in the Shared Global Area (oracle database)?
A bit unrelated (because that part didn't change that much) but you shouldn't be studying the documentation of a totally outdated and unsupported Oracle version. Read the manual for 11.x at least (if not 12.x), not 9.x
Jun
27
comment Why is PostgreSQL doing a seq scan on column != column?
On second thought: the optimizer could recognize that the condition is always false. I don't know why it doesn't. Maybe you should post this to the Postgres mailing list.
Jun
27
comment Do I need foreign keys in ORMs?
Another reason: I have never seen a database with vital (enterprise) information that was only accessed by a single application. So it is unlikely that the application (and thus that specific ORM) will be the only thing that writes to the database.
Jun
27
comment Oracle Enterprise Manage “CPU utilization” is confusing
Thanks. Put like that, it does make sense ;)
Jun
27
comment How to run oracle PL/SQL in C++?
I don't know C++ but in JDBC you cannot send more than one statement using the execute() function. I assume this is a restriction imposed by the Oracle protocol and therefor I would guess it's not possible in C++ either. You will need to split your script and run each statement individually and do the transaction handling in the C++ code
Jun
26
comment PostgreSQL using count() to determine percentages (cast issues)
Of course you are right, the window function is not needed. But then it doesn't really make a difference (apart from readability).
Jun
25
comment Performance issue in Postgresql9.3
Unrelated but: work_mem = 30GB is way to high. The 30GB may be allocated multiple times per statement (for each sort/hash step during execution).
Jun
24
comment How list of netezza system tables/views?
If Netezza supports transactions, then there can't be such a view. If you have multiple transactions all deleting and inserting rows into a table at the same time, which row count should that view show you?
Jun
24
comment How to print ORDER wise using LEFT JOIN in SQL?
An order by in a derived table (or a sub-select) does not make any sense. You need to apply the order by to the complete query (not the derived table).
Jun
23
comment ORA-00907: missing right parenthesis on query with subqueries
Actually except is defined in the SQL standard. It's not specific to SQL Server. But apart from that, you are right. minus is Oracle's implementation of the standard except operator
Jun
23
comment Issue working with Postgres on Windows
Try the psql command on a real Windows commandline, not from within pgAdmin. Maybe pgAdmin doesn't pass the parameters correctly
Jun
23
comment Issue working with Postgres on Windows
But according to the manual -f should be equivalent to \i
Jun
23
comment How to improve query performance in PostgreSQL?
Ah, sorry. That was a typo. It should of course be work_mem
Jun
23
comment General tuning in PostgreSQL
wiki.postgresql.org/wiki/Performance_Optimization
Jun
23
comment Maximum limit for COPY FROM STDIN in postgres
What is a "4 lakh file"?