Code Magician

Code Magician has asked 3 questions and find answers to 60 problems.

Stats

About

Software engineer, skydiver, biker, gambler, dreamer and fool.

Code Magician questions

DXIMageTransform.Microsoft.Matrix blurry in IE9
mod_rewrite only on GET

Code Magician answers

Drop/Rebuild indexes during Bulk Insert
SQL GROUP BY selecting
Query JOIN or not? (optimization)
Mysql create SQL subquery ALIAS
SQL statement to get record datetime field value as column of result
Canonical expression of "union" or "variant record"?
Select 2 distinct columns in 4GL
Any ideas for ROLLBACK TRANSACTION on this SQL statement
How to save large html content in database ? developing CMS
What are the pros and cons of one master base table which all entities inherit from?