11,197 reputation
11843
bio website
location Munich
age
visits member for 3 years, 2 months
seen 37 mins ago

Nov
5
comment Mysql with index
You don't "use" indexes. The optimizer chooses them automatically if it makes sense. And they don't change the result of a query, they improve the speed, that's all.
Nov
5
revised Mysql with index
improved formatting
Nov
5
comment Mysql with index
What do you mean with "implement index"? That doesn't make sense. Indexes are created (using a create index like the one you have) - they are not "implemented".
Nov
5
comment Mysql with index
What is your question?
Nov
5
comment Automatic conversion of anonymous records returned from an UDF to well known table-type
If the function does not have arguments, you could wrap that into a view.
Nov
4
comment Can NoSQL databases cause occasional data loss?
According to Murphy's law (and my own experience) you can lose data with any database.
Nov
4
comment Databases: are there universal datatypes?
@ypercube: ah right! I always forget that.
Nov
4
answered Databases: are there universal datatypes?
Nov
4
comment Handling case-insensitive queries with case-sensitive data
Postgres has a pretty decent full text search to solve exactly that problem.
Nov
3
comment How to change temporary directory for pg_dump?
I guess that is the temp file that gzip uses, not one from pg_dump
Nov
2
comment PostgreSQL crashes upon startup
I don't know if this is an option for your, but Postgres 9.3 "fixed" this problem by requiring much less System V shared memory.
Nov
1
comment How can place SQL Server online on the internet?
Port scanners will scan every open port, so obscuring the port by changing it won't improve securty at all.
Oct
31
revised remote query bloats tempdb
edited tags
Oct
31
comment WHAT RDBMS ( SQL SERVER/ ORACLE ) close to manage MYSQL(DBA)
That question does not make any sense
Oct
31
comment WHAT RDBMS ( SQL SERVER/ ORACLE ) close to manage MYSQL(DBA)
Short answer: none. Only MySQL syntax is "close to" MySQL syntax.
Oct
30
revised How to select the first row of each group?
Oracle needs the statement terminator at the end of the statement.
Oct
27
awarded  Custodian
Oct
27
reviewed No Action Needed Not able to login on MySQL in AWS RDS using root
Oct
27
reviewed Leave Closed T- SQL Query which can give all the Performance Monitoring information of a single database in SQL Server 2008 R2
Oct
26
answered Can column name be “Group” in Postgresql or in any databases