Reputation
15,286
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 27 53
Newest
 Reviewer
Impact
~1.1m people reached

2d
answered Postgres 9.3: How to update row that has max value of a timestamp in addition to other selection criteria?
2d
reviewed No Action Needed Schema review for system to advertise cars
2d
reviewed No Action Needed Can I select data inserted in the same uncommited transaction?
2d
answered Create a default value for session valid_until MySQL
2d
comment Error when creating multiple tables at once
Try adding an extra carriage return after the end of each statement (after the );, to separate the statements out.
2d
reviewed Approve What is the best way to analyze free space in a postgres database and the grow of usage?
2d
comment Load file based on line number in sqlldr
Looks like the best thing for you to do is use an external table, rather than sqlldr, and make use of RECNUM
Apr
22
answered Load file based on line number in sqlldr
Apr
19
reviewed No Action Needed "Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio
Apr
19
reviewed Close Opinion on Database Design for Task
Apr
19
reviewed Close Crashing CLR on SQL Server 2014 (windows 2012R2)
Apr
19
reviewed Close "Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio
Apr
19
reviewed Close Fetch data from second table based on first table
Apr
19
reviewed Close Add one column from another table
Apr
19
comment Mysql 5.6 very slow on windows server 2012 compared to other platforms
It's DDL. It doesn't matter. You just don't worry about performance tuning DDL. Sorry.
Apr
19
comment Mysql 5.6 very slow on windows server 2012 compared to other platforms
It really is completely dependant on the hardware, how warm the cache is on each box, and that's just a starter. Repeat the test with instrumentation and it will make a good question for the site, but as it stands there's no sane answer.
Apr
19
comment Mysql 5.6 very slow on windows server 2012 compared to other platforms
Unless you're getting a new customer every second, no. Build it into your app logic. Really isn't a problem. Might want to rethink your app design if you're going to end up with thousands of schemas/users.
Apr
19
comment Mysql 5.6 very slow on windows server 2012 compared to other platforms
Don't really get what the problem is, to be honest. Creating tables is a 1 time thing. A few seconds is nothing. Are you seeing problems inserting tens of thousand rows a second into those tables? If so, we can help.
Apr
17
reviewed No Action Needed How to interpret Mongo MMS Stats?
Apr
17
reviewed No Action Needed Load key/value set into redis