Why Analytic Workloads are faster on Columnar Databases?
In this post I will briefly summarize why analytic (OLAP) workloads perform better on columnar (aka column-oriented) databases as opposed…
PostgreSQL, Backups and everything you need to know
https://www.compose.com/articles/postgresql-backups-and-everything-you-need-to-know/ In his latest Write Stuff article Robert Wysocki explains PostgreSQL backups, how to pick which ones to do and…
Left join and Left outer join in SQL Server
http://stackoverflow.com/questions/406294/left-join-and-left-outer-join-in-sql-server As per the documentation: FROM (Transact-SQL): <join_type> ::= [ { INNER | { { LEFT | RIGHT | FULL…
What is the difference between UNION and UNION ALL.
http://stackoverflow.com/questions/49925/what-is-the-difference-between-union-and-union-all UNION removes duplicate records (where all columns in the results are the same), UNION ALL does not. There is…