In this post I will briefly summarize why analytic (OLAP) workloads perform better on columnar (aka column-oriented) databases as opposed to traditional row-based (aka row-oriented) databases. Introduction Storage Organization Vectorized…

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 what the pros and cons are.Could you write about databases?…

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 } [ OUTER ] } } [ <join_hint> ] ]…

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 a performance hit when using UNION vs UNION ALL, since…