Monthly Archives: September 2008

Why is Booze Measured in Proof?

The proof of an alcoholic beverage is not simply twice the percentage alcohol. In the 18th century and until 1980, Britain defined alcohol content in terms of proof spirit, which was defined as the most dilute spirit that would sustain combustion of gunpowder.[1] The term originated in the 18th century, when payments to British sailors […]

Avoid Correlated Subqueries

If your SQL code has a nested select that references a column in an outer select, such as the following, it may be possible to rewrite to perform orders of magnitude faster. proc sql; create table new_rates as select from work.exchange_rate n where not exists( select from imf.exchange_rate o where n.effective_date=o.effective_date and n.iso_char_code=o.iso_char_code ); NOTE: […]

Using WGET with HTTP GET Parameters

WGET is a simple tool that is usually on a lot of shell boxes. I think it might be installed by default on Linux. Sometimes you have to get it installed by your admin. At any rate, it’s useful for downloading a resource from a simple web service like so: WGET http://www.asdf.com/jkl.html You can even […]

Pop vs. Soda vs. Coke

It’s no surprise to me that the south calls it “coke”, and the yankees call it “soda”, and those crazy north midwesterners call it “pop” (haha!), but the interesting thing is there’s a large pocket of “soda” in Missouri. I wonder why that is?

T_PAAMAYIM_NEKUDOTAYIM

Parse error: syntax error, unexpected T_PAAMAYIM_NEKUDOTAYIM in file on line line Paamayim Nekudotayim means “twice colon” in Hebrew. It is PHP’s name for the “::” operator. PHP’s Zend engine is Israeli-developed. http://us.php.net/manual/en/language.oop5.paamayim-nekudotayim.php