Technology, Politics, Businness, Entertainment
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> ::= } } ] JOIN The keyword OUTER is marked as optional (enclosed in square brackets), and what this means in this…
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…