Walter Mitty

199 reputation

bio	website
	location
	age
visits	member for	2 years, 2 months
	seen	yesterday
stats	profile views	25

	199 reputation	bio	website		visits	member for	2 years, 2 months
6 badges		location			seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

39 Actions

suggestions reviews revisions comments badges posts accepts all

May 18	awarded	Commentator
May 18	comment	3nf but waste more storage space Wasted space is a minor issue when considering normalization or the alternatives. Two bigger issues are whether you are going to allow the database to get into a self contradictory state or not, and how much of a performance hit are you going to take doing joins.
May 15	answered	How do I use subquery on the same table in MySQL?
May 15	comment	Are all matching indexes (indices) searched for a query? If we throw in range retrievals as well as lookups, and merge joins, it depends even more on how the optimizer works.
May 14	answered	Using a keywords table with multiple other tables
May 14	comment	How to merge data from 2 databases Do you possibly mean "merge the transactions" rather than "merge the databases"? If so, whatever solution is put forward will be subject to the possiblity that some transactions that were allowed in the actual scenario would have been disallowed if the the 5/2 transactions had been applied before the 5/3 transactions were attempted.
May 14	comment	Validate each parent intermediary is also a parent to itself The wording of your question is too vague. It allows multiple interpretations, which could lead to multiple mutually contradictory answers.
May 13	answered	Empty LONGTEXT or NULL?
Apr 21	revised	How should I store multiple relationships (many posts to many categories)? Changed title to indicate many to many
Apr 21	comment	How should I store multiple relationships (many posts to many categories)? +1 for identifying the problem as many-to-many. The original title indicated many-to-one.
Apr 21	suggested	suggested edit on How should I store multiple relationships (many posts to many categories)?
Apr 6	comment	Refactoring/normalization - but almost empty table The word "query" doesn't appear in the reqwuirements. What requirement does it fulfill?
Apr 4	answered	How can I improve my table design for different types of an entity?
Apr 2	comment	Why is Database Administration so hard? +1 for don't be afraid to brush up on your people skills.
Apr 2	awarded	Supporter
Apr 2	answered	Estimated Execution Plan SQL Server Sort?
Mar 31	answered	Why is Database Administration so hard?
Mar 24	awarded	Quorum
Mar 16	revised	How to model inheritance of two tables mysql Re worked to make back references to tag info in SO.
Mar 15	revised	How to model inheritance of two tables mysql Added explanation for the non existence of the three tags