Monthly Archives: September 2013

Bare Butt

We’ve been getting a few old Disney movies lately. Mary Poppins and Pollyanna arrived a few days ago. Pollyanna starts with a scene of a little boy rope-swinging into a bunch of other kids skinnydipping in the local pond.  I … Continue reading

Posted in Parenting, Quote of the Day | Leave a comment

Slow-growing SQL Server transaction log

Our MES system has a reasonably-sized transaction log; 9GB for a 3GB primary database. This is somewhat larger than normal recommendations (1.5x), but we import large volumes of batch data each morning which increases the number of transactions  and pushes … Continue reading

Posted in SQL Server, System/DB Administration | Leave a comment

OMG, CTE TVF and UDF

O M G. https://www.simple-talk.com/sql/t-sql-programming/sql-server-apply-basics/ SO, SO helpful to understand how to restructure the LEFT OUTER JOINs in my Common Table Expression (CTE) to instead use User Defined Functions (UDFs) that return Table-Valued Functions (TVFs). Mr. Sheldon’s article brought everything together for me. My CTE … Continue reading

Posted in Programming, SQL Server | Leave a comment

How to change you car’s filters – Edmunds.com + Lifehacker.com

http://www.edmunds.com/how-to/how-to-change-your-cars-filters.html http://lifehacker.com/5830681/change-your-cars-air-filter

Posted in Home Maintenance | Leave a comment