Reputation
18,555
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
4 38 61
Newest
 Good Answer
Impact
~1.9m people reached

Apr
29
comment Wrong host name in newly created oracle 12c listener
What exact error message are you getting when you try and start the listener?
Apr
25
comment Need help improving query performance
Edit your question with details of the real create table statements, and the plan for the actual query
Apr
24
comment Help with query to find intersection between arbitary rows of a table under conditions
Just one comment, unrelated to your question. Do not use the SYS or SYSTEM users day-to-day in Oracle, and do not create objects in the SYSTEM schema.
Apr
22
comment how to uniformly select rows in sql
Which RDBMS are you using? There are a number of ways of doing this
Apr
22
comment IBM i Access ODBC driver returning only first letter of column names
Is it this? github.com/jiangwen365/pypyodbc/issues/25
Apr
22
comment IBM i Access ODBC driver returning only first letter of column names
Odd. What happens if you try and alias them using column1 as blahblah?
Apr
17
comment SQL query for matrix multiplication
Which RDBMS are you using?
Apr
15
comment XAMPP: MySQL not starting
You deleted the file... Just because it "came back" doesn't mean it has its original contents
Apr
14
comment PDO does not fetch any results
Try adding some error checking after the prepare and execute. Also, check that the $dbh you're passing is in fact valid
Apr
10
comment How can I create a user that can only create databases and users?
Sounds like a very odd requirement. Maybe something best achieved by scripting rather than direct database access
Mar
30
comment How to find out user activity for calls made from an application server?
Big SAP or SAP B1? Why do you need to do this?
Mar
27
comment Run Oracle queries on Sublime Text 3
xe by the look of it
Mar
27
comment Run Oracle queries on Sublime Text 3
Put the Oracle service name in there...
Mar
25
comment Find tables and views that are not in use at all?
I think this question is possibly misguided. Do you really just want to throw data away? It'll be in the database for a reason...
Mar
23
comment MySQL Slows Down after MYD file reaches 2GB (64 Bit OS)
If it's virtualised, is the storage sparsely provisioned? If so, having to extend the .vmdk files may explain the performance drop-off ?
Mar
23
comment is it problematic to cluster across two datacenters w/aag?
Which RDBMS? SQL Server, I guess?
Mar
22
comment MySQL Slows Down after MYD file reaches 2GB (64 Bit OS)
Virtualised or real box?
Mar
22
comment use IFNULL in laravel
Are you sure you don't want a left outer join?
Mar
22
comment use IFNULL in laravel
Try: DB:raw('IFNULL( downloads.is_download , 0 ) as is_download')
Mar
22
comment use IFNULL in laravel
IFNULL is a SQL function, not a PHP function, so you need to put: 'IFNULL( downloads.is_download , 0 )' (ie: with quotes)