Thanks for the article.

Just to emphasize the Hash table section some more. There is only 60 distributions that your Hashed key will be stored in. That means you...

Yeah, it's a bit difficult for my scenario though. I'm billion with billions of rows. Triggers and other checks are removed to improve performance. Pretty similar to the recent article...

Late to the thread here. I can give you a scnerio where I have no PK. I like being the black sheep.

I have had large tables where 15+...

I mostly game as my avatar suggests. Right now, I've been doing non-stop dungeon crawls in Diablo 3.

Outside of my computer, I do have a wife and 2...

At a very high level, you can load your dimensions first and then apply your foreign keys from those dimensions back onto your data. Once that's done, you can then...

Google BigQuery also supports Updates now too.

Now you're getting into semantics. This is how columnstores work in general. They are not referred to the way they store and retrieve this data as indexing regardless of how...

Here is a write up how it actually works for one of them.

http://static.googleusercontent.com/media/research.google.com/en//pubs/archive/36632.pdf

Glad you seem to think that the secret to these technologies is just...