blunders

172 reputation

bio	website
	location
	age
visits	member for	1 year, 7 months
	seen	Aug 26 '12 at 15:52
stats	profile views	31

Ask a question on the new Linguistics site on Stack Exchange.

	172 reputation	bio	website		visits	member for	1 year, 7 months
8 badges		location			seen	Aug 26 '12 at 15:52

summary answers questions tags badges favorites bounties reputation activity

52 Actions

suggestions reviews revisions comments badges posts accepts all

Aug 28	comment	Optimizing MySQL - @Josh: Confused, you said you set max_connections to 512, but the dump you posted appears to say it's set to 100. Also, is it correct that the database is using INNODB and MyISAM? As for Opened_tables that appears to just be the number of tables that have been opened since startup; believe Open_tables is what you're looking for, which is the number of tables that are open at the moment. (MySQL is so much fun!)
Mar 15	accepted	Best practices for finding and updating a handful of records?
Mar 15	accepted	Effect of Oracle on MySQL
Mar 5	awarded	Quorum
Feb 29	revised	Managing schema changes between transactional and analytical databases Formatted the title as a question
Feb 29	comment	Managing schema changes between transactional and analytical databases +1 @ConcernedOfTunbridgeWells: Great, thank you -- that's what both my friend and I thought, though on the off chance there was a known "way" to manage "continuous integration" between the databases I wanted to know; in part because I'm guessing in a not to uncommon issue. Cheers!
Feb 29	accepted	Managing schema changes between transactional and analytical databases
Feb 29	comment	Managing schema changes between transactional and analytical databases +1 @ConcernedOfTunbridgeWells: I just completed an attempt to improve the question's intent and structure. If you have any additional feedback, let me know.
Feb 29	revised	Managing schema changes between transactional and analytical databases Attempt to improve the question's intent and structure
Feb 29	revised	Managing schema changes between transactional and analytical databases typo
Feb 29	revised	Do agile software development approaches apply to SQL? Edited title to fix what I believe to be grammatical errors
Feb 29	suggested	suggested edit on Do agile software development approaches apply to SQL?
Feb 28	asked	Managing schema changes between transactional and analytical databases
Feb 14	comment	Getting to know SQL via the “short questions/simple answers style of learning” +1 Wow, I've been looking on and off for that for over a year, thank you!
Feb 13	revised	Why did Microsoft kill “English Query” on SQL Server? Added the time that MS provided the info, since that is important info.
Feb 13	comment	Getting to know SQL via the “short questions/simple answers style of learning” +1 @yogirk: I tried it out, and agree it's nice. That said, within less than 5-mins of installing it I ran across one bug; the load file function referenced a file that does not exist. Also, on the first page of the tutorial it asks you to figure out how many seconds are in a day, but never says at any point to the user how to do it, or infer it from other examples; the answer being "SELECT 246060". So, basically after those issues I stopped trying it, might try it more later, but also agree it not the format I describe; which leads to the student internalizing that material I believe.
Feb 13	awarded	Critic
Feb 13	comment	Why did Microsoft kill “English Query” on SQL Server? -1 Speculative, and not a fact-based answer.
Feb 13	comment	Why did Microsoft kill “English Query” on SQL Server? +1 @Jack Douglas: For not closing the question, and backing up that there is "doubtless a definitive answer and it might surface someday" - which it did, thanks!
Feb 13	comment	Why did Microsoft kill “English Query” on SQL Server? +1 @Martin Smith: Great, thank you -- just curious, how did you find it? (Meaning for example the Google query that lead you to find it, since I tried everything I could think of and was unable to find anything from MS.) Again, thanks!