68,888 reputation
1070160
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 9 months
seen 1 hour ago

One of JEHOVAH's Witnesses (TV)

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


2d
reviewed Looks OK Mysql innoDB write operations are extremely slow
2d
reviewed Close date wise report and order by date
2d
reviewed Close Best way to profile SQL Server
2d
reviewed Leave Open Duplicate values
2d
reviewed Close New To SQL and looking for some advice
2d
revised Increase performance WITHOUT adding indexes
added 61 characters in body
2d
comment Duplicate values
DBA SE Community : Please don't close this. I have the answer (dba.stackexchange.com/a/83589/877)
2d
revised Increase performance WITHOUT adding indexes
added 2129 characters in body
Nov
25
revised Duplicate values
added 1931 characters in body
Nov
25
answered Duplicate values
Nov
25
revised Is this update, select combination query thread safe?
deleted 11 characters in body
Nov
25
comment Is this update, select combination query thread safe?
At first, I was thinking that the first SELECT triggers the lock and the second SELECT does the actual retrieval. Now that I think about it, the SELECT id INTO @available_id from seats WHERE taken is null limit 1 FOR UPDATE; is most likely sufficient.
Nov
25
answered Increase performance WITHOUT adding indexes
Nov
25
reviewed Leave Open Increase performance WITHOUT adding indexes
Nov
24
reviewed Close How to determine next value to use in composite key in SQL Server?
Nov
24
reviewed Close How to recover Database System MDF and Ldf files and transaction ldf lifes
Nov
24
reviewed Close Merge two databases, postgres
Nov
24
reviewed Close Finding Microsoft Access Database Connection
Nov
24
reviewed No Action Needed Performance decline function vs command window
Nov
24
reviewed No Action Needed Sudden (and drastic) decrease in commands/second on replicated slave