Posts

S&P 500 Rolling 30 Year Annual Returns

Image
 S&P 500 Rolling 30 Year Annual Returns Great visual from  https://awealthofcommonsense.com/2020/10/how-comfortable-are-you-holding-stocks-for-30-years/

Annualized Returns During Presidential Terms

Image
  Image lifted from https://ritholtz.com/2020/10/random-thoughts-2020-election/ 

FAQs on Protecting Yourself from COVID-19 Aerosol Transmission

  FAQs on Protecting Yourself from COVID-19 Aerosol Transmission I'm not certain how long this link will be available, but as of Oct 3rd 2020 it seems to be some of the best collected data points for understanding the Aerosol spread of COVID-19 and how to reduce your risk of invection. https://docs.google.com/document/d/1fB5pysccOHvxphpTmCG_TGdytavMmc1cUumn8m0pwzo/preview?pru=AAABdQ5s5mA*YrLy9epGlHWhKPSl5JMT3w#heading=h.k10zp34x5s0p

A great description of conservative versus progressive

David Schell wonders the same thing I've been wondering - 'Why all of these posts and stories about pedophilia?"  Only he actually puts his thoughts into words and posts.  Including a quote from Footloose.  https://davidmschell.com/conservatives-pedophilia/

New Effort - Bookmarking graphs of things that are true so I can refer to them later

Image
 I'm not a numbers person, although I work with numbers all the time.  Maybe it's not so much that I'm not a numbers person as I just can't remember any numbers.  So when discussing things of importance, with people that are ill-informed, I need a reliable place I can go to grab those facts, or charts, or statistics.  After thinking about this problem for a few months, it occurred to me "Hey, I have a blog!!  I'll just put stuff there!"  So a few more months go by and we are finally here - I'm ready to post my first link. I anticipate these posts might simply be links to other web pages, I still have to figure out the details.  So I'm just going to plunge right in and begin, and worry about those pesky details later. https://www.statista.com/chart/22727/seasonally-adjusted-real-gdp-in-the-us/

Selecting into a view with no where clause is much faster that adding a where clause

Pulling my hair out with this. The following query returns in 9 seconds if the where clause is omitted, but takes minutes with a where clause. A select all into a temp table and issuing the where clause on the temp table takes ~22secs. SELECT Style AS Item ,Color ,[Size] ,QtyAvailable ,UPC ,Status ,DateAvailable AS EstimatedAvailDate FROM [LAN_VW_B2B_Upcs] WHERE ItemGroup = 'FG' AND ProductSegment IN ('BASIC', 'CORE', 'POS') AND Brand NOT IN ('IL')

Quick Update on Nexenta and Super Micro

Just a quick note regarding our Nexenta storage solution. Sunday afternoon a few weeks back (why do these things always happen on weekends) we had a truck knock over a utility pole just down the street from our office and we lost power to the building. Our server room contains one badly underpowered UPS with no generator backup so it wasn't long before everything in the room was shut down. I cancelled my plans, headed into the office and waited for power to get restored, then proceeded to power everything back up (This is always a nerve wracking time). All went well with one exception - Nexenta reported being unable to see any disks in my array and therefore failed to mount any shares. All our data drives are housed in our Super Micro 836E2-R800B JBOD Chassis. I headed into the server room and the system light was on but no lights on any of the drives. Rebooting the Nexenta head unit did not resolve the issue. After a 20 minutes of high anxiety I noticed the power supplies...