75,995 reputation
1176173
bio website
location Jersey City, NJ (USA)
age 50
visits member for 4 years, 1 month
seen 3 mins ago

Jul
16
reviewed Reviewed Do roles have an owner in oracle?
Jul
16
answered Windows Service Management Node Won't Start
Jul
16
revised Windows Service Management Node Won't Start
Added 'ndbcluster' tag
Jul
16
comment Select statement with dynamic columns where these columns are rows in another table
All this and no information_schema involvement? Wow !!! This is worth a +2, but you'll have to settle for +1 !!!
Jul
16
comment Remove InnoDB files (ibdata1 and iblog files) after migration to MyISAM
If you remove them, a mysql startup will just regenerate them. Perhaps --skip-innodb should be added to /etc/my.cnf after shutting down and deleting, but before starting back up.
Jul
16
comment Remove InnoDB files (ibdata1 and iblog files) after migration to MyISAM
+1 for the MySQL 5.6 caveat.
Jul
16
reviewed Edit Remove InnoDB files (ibdata1 and iblog files) after migration to MyISAM
Jul
16
revised Remove InnoDB files (ibdata1 and iblog files) after migration to MyISAM
Edit : updated
Jul
15
revised Get top most parent by nth child id?
edited body
Jul
15
comment Get top most parent by nth child id?
I guess that's true if you are looking for the maximum depth. For a given depth, you would have to live the performance of the one query. Thank you for the +1 !!!
Jul
15
answered Get top most parent by nth child id?
Jul
15
revised Export just rows modified in last month (date defined by user)
added 14 characters in body
Jul
15
answered Export just rows modified in last month (date defined by user)
Jul
15
reviewed Reject Why Isn't the SQL Server Agent Service Set to Automatic Startup by Default?
Jul
14
awarded  Announcer
Jul
14
reviewed Approve COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query
Jul
13
reviewed Approve How do I minimise logging during a large insert?
Jul
12
revised multi master replication
added 230 characters in body
Jul
12
reviewed Leave Open multi master replication
Jul
12
comment InnoDB Failure of some kind
Did you ever get this solved ???