This is likely a query issue; I've had many queries go wild & OOM, once fixed they work as you'd expect. There's also a config setting you can use to limit in seconds the amount of time a query can run before it's killed, very useful if you plan on running hand built queries on anything production (which you shouldn't be anyways ;-))
Seriously, anytime I find a company that freely shares the details of a newer faster way, I'm more a fan. Though with the negative points MS has earned, they're still in the red in my book.
"Day 5 - Embarrassing Flaw #3: Making a stupid business plan, then ignore it anyway"
Awesome! (I lol'd) I love inventing. It's only recently that I've started to add business logic to my imagination, I'm no Jedi in this capacity, but the force was strong at startup school; and I want to train!