548 reputation
110
bio website
location
age
visits member for 1 year, 10 months
seen Oct 14 at 8:54

Jan
9
comment MySQL: why provide size of a datatype in table definition?
the manual you are referencing to gives an explanation as well: dev.mysql.com/doc/refman/5.1/en/numeric-type-attributes.html
Dec
11
awarded  Yearling
Aug
20
reviewed No Action Needed Is SQLT safe to run in production?
Aug
2
reviewed No Action Needed How to optimise T-SQL query using Execution Plan
Aug
1
reviewed No Action Needed Does disconnecting the network stop a query?
Aug
1
reviewed No Action Needed Updating TNS Entry across multiple terminals
Aug
1
reviewed No Action Needed Inline TVF with One Row Result
Aug
1
reviewed No Action Needed Select rows after a specific ID
Aug
1
reviewed No Action Needed Does disconnecting the network stop a query?
Aug
1
comment Running the DBT2 test results in 0.00 NOTPM
any output in $OUTPUT_DIR/client.out or $OUTPUT_DIR/driver.out 2>&1 ?
Jul
25
reviewed No Action Needed MS SQL Server 2005 DB backup with partitioned tables to non-partitioned SQL Server 2012
Jul
25
reviewed No Action Needed Restore MySQL DB from its folder
Jul
24
comment Deleting the MySQL 'root' user on purpose
well, there is a RENAME USER command since 5.0 . If your clients can't connect after that change it obviously means that they were using the 'root' username to connect to MySQL
Jul
23
revised MySQL Large DELETE with JOINs
added info on how to obtain a EXPLAIN result for a DELETE
Jul
22
reviewed No Action Needed Merge rows with common field value in MySQL
Jul
22
answered MySQL 5.5 High CPU Usage
Jul
22
answered MySQL Large DELETE with JOINs
Jul
22
reviewed Reviewed Query taking too long to execute
Jul
22
comment Query taking too long to execute
please include EXPLAIN output for your query. Also SHOW CREATE TABLE for your tables would be helpful.
Jul
22
answered MySQL Replace function throwing error