Reputation
611
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 10
Newest
 Yearling
Impact
~39k people reached

Apr
10
comment Mysql query to find nth largest entry in a column
Beware that the "LIMIT offset,number" approach does have performance implications on large offsets, i.e. the bigger offset is the more rows have to be scanned (and possibly JOINed) to get the right ones. This can hinder performance of complex queries severely.
Apr
10
answered On triggers and replication in MySQL
Jan
5
answered DROP PROCEDURE IF EXISTS not included in mysqldump
Dec
11
awarded  Yearling
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