Blabberbox:Random blog-like posts by pftq and his related selves.Share on Twitter

Journey's End

November 26th, 2015 | Posted by pftq in Stuck in My Head | #
Journey's End by Kaz Okamoto
211 unique view(s)

Terrorists Among Syrian Refugees

November 15th, 2015 | Posted by pftq in Blabberbox | #
Looks like the ISIS Trojan Horse scenario I mentioned in September is playing out with the mass migration of refugees to Europe.  Terrible news this past Friday, but can't say it was unexpected.  It was also literally spelled out by ISIS as what they intended to do (flood Europe with migrants and hide among them).

The news here at least acknowledges that rather than treat it as a completely unpredictable event like they often do: http://edition.cnn.com/2015/11...

Just hope the Western world takes the vulnerability of opening up to mass immigration a little more seriously now, but it seems like politicians these days have worked themselves into a corner where they must always do the most short-term, emotionally righteous decision rather than think things through on a longer term, more rational perspective.  The problem is they're always reacting to events instead of thinking one step ahead.  It's almost as if they'd rather endure crisis after crisis together rather than make the tough call against the herd to prevent one.  No matter what they do now with the immigration issue (close, tighten, whatever), whoever wanted to sneak in is already in, and they need to start looking past that.
73 unique view(s)

Buried Memories

November 9th, 2015 | Posted by pftq in Stories | #
Another dream I had that played out like a movie.  Seems to be how all my ideas to come to me now.
================================
I am living off in the country side for some time.  There, I have a small isolated plot of land that I planted a farm on and regularly tend to for fun, but the house near it is pretty high tech and is where I do a bunch of more serious work for coding and other hobbies.  One day, some guy shows up while I'm out on my farm and tries to tell me I ought to work for his company and get a real job or something.  He starts telling me how it will be good experience to build resume and get real software skills, etc so I don't have to live on a farm anymore.  I ask if he knows what I actually do, and he says he can't tell, which just annoys the heck out of me that he'd dare even tell me what I should do with my life.  I show him that my farm is actually also a grave for past lives I've had and previous bodies I've...[More]
33 unique view(s)

Helping vs Changing Goals

October 26th, 2015 | Posted by pftq in Thought of the Day | #
You don't help someone by telling them to change their goal.  If you're going to help them, help them achieve it.
228 unique view(s)

Imposing on Others

October 11th, 2015 | Posted by pftq in Thought of the Day | #
Having a person complain while he imposes his will on others is like watching a dog cry while it devours a child.
278 unique view(s)

Performance Issues in SQL Server 2014

October 10th, 2015 | Posted by pftq in Blabberbox | #
I just spent the last week trying to figure out why some of my SQL queries were suddenly taking hours to run on a large dataset when they used to take seconds on an older machine.  The queries I have use a lot of subqueries and left-joins across several tables with hundreds of GB of data each.  At first I thought it might be because my dataset has grown to the point my queries were no longer efficient.  Perhaps I had too many joins or subqueries that were not using the indexes on the table.  I actually tried removing every case of "OR" condition in my queries, which seemed to help a little but nowhere near bringing down the hour or so it still took to run.  After messing with indexes and re-arranging queries non-stop, it turns out it's because of an update to cardinality estimation on the back-end in Microsoft SQL Server 2014.

Luckily, you can disable the cardinality estimation update on a query-by-query basis by doing:
Quote
*your query*   OPTION ( QUERYTRACEON 9481 )

After appending "  OPTION ( QUERYTRACEON 9481 )" at the end of my queries, I'm back to seeing them execute within seconds.  Whatever update Microsoft did to its cardinality estimation clearly missed a few edge cases (perhaps they don't expect large queries and datasets?).  If anyone else is running into this issue, I hope this saves them some time.  Bigger worry is if Microsoft thinks their update is so great that they end up removing the ability to backtrack down the road.
82 unique view(s)

Wasting Through Time

October 3rd, 2015 | Posted by pftq in Stories | #
This was another story idea I got as a dream.  I suppose it reflects my mood lately with everyone seeming to get older around me, not just physically but mentally as well.

=========================

Two friends have known each other all their lives.  They are able to time travel but only by skipping forward in time.  They've been doing that for a while and have experienced centuries of history past by, but one day, one of the friends loses this ability.  The other is torn between staying with the friend or leaving the friend behind to continue skipping forward.  There was a sense before that both of them were destined to see all the Earth's history to the very end until the world goes dark, but now that seems less certain.  They end up splitting ways, with one living through the years instead of skipping forward while the other continues to jump forward every few years.  Each time they catch up, one friend gets much older while the other remains...[More]
48 unique view(s)

Builders vs Maintainers

October 1st, 2015 | Posted by pftq in Thought of the Day | #
Sometimes it's like I'm building a house and this guy thinks he's helping by saying it needs a roof.
286 unique view(s)