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


O M G. 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 – +

Posted in Home Maintenance | Leave a comment