corpus.blog
41554 blogs · [ { "id": "01a0c566-ed3c-738f-a3e5-8087b4ff80d2", "title": "Shuffling rows: PostgreSQL", "url": "https://explainextended.com/2009/10/06/shuffling-rows-postgresql/", "published_at": "2009-10-06T19:00:08+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b590c164", "title": "Date range with possible NULL values", "url": "https://explainextended.com/2009/10/05/date-range-with-possible-null-values/", "published_at": "2009-10-05T19:00:16+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b6620ba5", "title": "Bitwise operations and indexes", "url": "https://explainextended.com/2009/10/01/bitwise-operations-and-indexes/", "published_at": "2009-10-01T19:00:01+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b715a0e4", "title": "IN vs. JOIN vs. EXISTS: Oracle", "url": "https://explainextended.com/2009/09/30/in-vs-join-vs-exists-oracle/", "published_at": "2009-09-30T19:00:16+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b726f1dc", "title": "Adjacency list vs. nested sets: MySQL", "url": "https://explainextended.com/2009/09/29/adjacency-list-vs-nested-sets-mysql/", "published_at": "2009-09-29T19:00:42+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b811de3a", "title": "Adjacency list vs. nested sets: Oracle", "url": "https://explainextended.com/2009/09/28/adjacency-list-vs-nested-sets-oracle/", "published_at": "2009-09-28T19:00:03+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b84239bf", "title": "Adjacency list vs. nested sets: SQL Server", "url": "https://explainextended.com/2009/09/25/adjacency-list-vs-nested-sets-sql-server/", "published_at": "2009-09-25T19:00:49+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b9011018", "title": "Adjacency list vs. nested sets: PostgreSQL", "url": "https://explainextended.com/2009/09/24/adjacency-list-vs-nested-sets-postgresql/", "published_at": "2009-09-24T19:00:35+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b9459373", "title": "Building alphabetical index", "url": "https://explainextended.com/2009/09/23/building-alphabetical-index/", "published_at": "2009-09-23T19:00:57+00:00" }, { "id": "01a0c566-ed3c-738f-a3e5-8087b99dce76", "title": "Finding sets within a time frame", "url": "https://explainextended.com/2009/09/22/finding-sets-within-a-time-frame/", "published_at": "2009-09-22T19:00:40+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c91cee79dc", "title": "Rounding numbers preserving their sum", "url": "https://explainextended.com/2009/09/21/rounding-numbers-preserving-their-sum/", "published_at": "2009-09-21T19:00:15+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c91dce6fe2", "title": "NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQL", "url": "https://explainextended.com/2009/09/18/not-in-vs-not-exists-vs-left-join-is-null-mysql/", "published_at": "2009-09-18T19:00:14+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c91e1ab5a5", "title": "NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: Oracle", "url": "https://explainextended.com/2009/09/17/not-in-vs-not-exists-vs-left-join-is-null-oracle/", "published_at": "2009-09-17T19:00:41+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c91e536125", "title": "NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: PostgreSQL", "url": "https://explainextended.com/2009/09/16/not-in-vs-not-exists-vs-left-join-is-null-postgresql/", "published_at": "2009-09-16T19:00:59+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c91e9448f4", "title": "NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: SQL Server", "url": "https://explainextended.com/2009/09/15/not-in-vs-not-exists-vs-left-join-is-null-sql-server/", "published_at": "2009-09-15T19:00:43+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c91eaa69ed", "title": "MySQL: emulating ROW_NUMBER with multiple ORDER BY conditions", "url": "https://explainextended.com/2009/09/14/mysql-emulating-row_number-with-multiple-order-by-conditions/", "published_at": "2009-09-14T19:00:20+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c91f47772d", "title": "SQL Server 2005: finding foreign keys that have no index", "url": "https://explainextended.com/2009/09/10/sql-server-2005-finding-foreign-keys-that-have-no-index/", "published_at": "2009-09-10T19:00:49+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c9201cec99", "title": "Oracle: generating a list of dates and counting ranges for each date", "url": "https://explainextended.com/2009/09/09/oracle-generating-a-list-of-dates-and-counting-ranges-for-each-date/", "published_at": "2009-09-09T19:00:04+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c9206479e2", "title": "MySQL: matching whole sets", "url": "https://explainextended.com/2009/09/08/mysql-matching-whole-sets/", "published_at": "2009-09-08T19:00:19+00:00" }, { "id": "01a0c56d-f381-72f3-8246-15c9209664c3", "title": "PostgreSQL: selecting items that belong to all categories", "url": "https://explainextended.com/2009/08/25/postgresql-selecting-items-that-belong-to-all-categories/", "published_at": "2009-08-25T19:00:06+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160a97cdf55", "title": "SQL Server: leading wildcard match using an index", "url": "https://explainextended.com/2009/08/24/sql-server-leading-wildcard-match-using-an-index/", "published_at": "2009-08-24T19:00:23+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160aa4df067", "title": "What is a relational database?", "url": "https://explainextended.com/2009/08/23/what-is-a-relational-database/", "published_at": "2009-08-23T19:00:14+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160aaf45586", "title": "SQL Server: finding date closest to a birthdate", "url": "https://explainextended.com/2009/08/21/sql-server-finding-date-closest-to-a-birthdate/", "published_at": "2009-08-21T19:00:59+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160ab9ca0ce", "title": "SQL Server: efficient DISTINCT on dates", "url": "https://explainextended.com/2009/08/20/sql-server-efficient-distinct-on-dates/", "published_at": "2009-08-20T19:00:27+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160abedac4d", "title": "MySQL: difference between sets", "url": "https://explainextended.com/2009/08/19/mysql-difference-between-sets/", "published_at": "2009-08-19T19:00:46+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160ac7a68aa", "title": "Passing parameters in MySQL: IN list vs. temporary table", "url": "https://explainextended.com/2009/08/18/passing-parameters-in-mysql-in-list-vs-temporary-table/", "published_at": "2009-08-18T19:00:48+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160acacf076", "title": "Hierarchical queries in MySQL: VARCHAR keys", "url": "https://explainextended.com/2009/08/17/hierarchical-queries-in-mysql-varchar-keys/", "published_at": "2009-08-17T19:00:35+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160ad69cf15", "title": "Presentation layer", "url": "https://explainextended.com/2009/08/16/presentation-layer/", "published_at": "2009-08-16T19:00:01+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160adb65845", "title": "Oracle: updating rows with partitioned incremental value", "url": "https://explainextended.com/2009/08/12/oracle-updating-rows-with-partitioned-incremental-value/", "published_at": "2009-08-12T19:00:19+00:00" }, { "id": "01a0c579-7f25-71b7-881f-a160ae5bb93a", "title": "Efficient date range query: SQL Server", "url": "https://explainextended.com/2009/08/11/efficient-date-range-query-sql-server/", "published_at": "2009-08-11T19:00:43+00:00" }, { "id": "01a0c587-833e-7267-9d60-14369abe2f86", "title": "Fallback language names: MySQL", "url": "https://explainextended.com/2009/08/10/fallback-language-names-mysql/", "published_at": "2009-08-10T19:00:10+00:00" }, { "id": "01a0c587-833e-7267-9d60-14369bac38c0", "title": "Fallback language names: PostgreSQL", "url": "https://explainextended.com/2009/08/08/fallback-language-names-postgresql/", "published_at": "2009-08-08T19:00:59+00:00" }, { "id": "01a0c587-833e-7267-9d60-14369c047996", "title": "Fallback language names: SQL Server", "url": "https://explainextended.com/2009/08/07/fallback-language-names-sql-server/", "published_at": "2009-08-07T19:00:07+00:00" }, { "id": "01a0c587-833f-71d4-8097-c187e3a91f37", "title": "Fallback language names: Oracle", "url": "https://explainextended.com/2009/08/06/fallback-language-names-oracle/", "published_at": "2009-08-06T19:00:42+00:00" }, { "id": "01a0c587-833f-71d4-8097-c187e3eee6f9", "title": "MySQL: LIMIT on LIMIT", "url": "https://explainextended.com/2009/08/05/mysql-limit-on-limit/", "published_at": "2009-08-05T19:00:31+00:00" }, { "id": "01a0c587-833f-71d4-8097-c187e4ed8873", "title": "SQL Server: deleting adjacent values (improved)", "url": "https://explainextended.com/2009/08/04/sql-server-deleting-adjacent-values-improved/", "published_at": "2009-08-04T19:00:31+00:00" }, { "id": "01a0c587-833f-71d4-8097-c187e57e26ec", "title": "SQL Server: deleting adjacent values", "url": "https://explainextended.com/2009/08/03/sql-server-deleting-adjacent-values/", "published_at": "2009-08-03T19:00:04+00:00" }, { "id": "01a0c587-833f-71d4-8097-c187e631ae1c", "title": "MySQL: DISTINCT on DISTINCT", "url": "https://explainextended.com/2009/08/01/mysql-distinct-on-distinct/", "published_at": "2009-08-01T19:00:09+00:00" }, { "id": "01a0c587-833f-71d4-8097-c187e6c8b6d3", "title": "MySQL: counting items in pairs", "url": "https://explainextended.com/2009/07/31/mysql-counting-items-in-pairs/", "published_at": "2009-07-31T19:00:50+00:00" }, { "id": "01a0c587-833f-71d4-8097-c187e74b204a", "title": "PostgreSQL: making duplicate records unique", "url": "https://explainextended.com/2009/07/30/postgresql-making-duplicate-records-unique/", "published_at": "2009-07-30T19:00:02+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e246358ebb0", "title": "PostgreSQL 8.4: efficient MIN(COUNT(*))", "url": "https://explainextended.com/2009/07/29/postgresql-8-4-efficient-mincount/", "published_at": "2009-07-29T19:00:51+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e2464509f88", "title": "SQL Server: random records avoiding CTE reevaluation", "url": "https://explainextended.com/2009/07/28/sql-server-random-records-avoiding-cte-reevaluation/", "published_at": "2009-07-28T19:00:37+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e24651113dc", "title": "Dynamic pivot", "url": "https://explainextended.com/2009/07/27/dynamic-pivot/", "published_at": "2009-07-27T19:00:07+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e2465f10cec", "title": "MySQL: selecting rows before and after filtered one", "url": "https://explainextended.com/2009/07/25/mysql-selecting-rows-before-and-after-filtered-one/", "published_at": "2009-07-25T19:00:56+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e246671d3c4", "title": "MySQL: grouping continuous ranges", "url": "https://explainextended.com/2009/07/24/mysql-grouping-continuous-ranges/", "published_at": "2009-07-24T19:00:46+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e2467010272", "title": "PostgreSQL: last 12 weeks of a year", "url": "https://explainextended.com/2009/07/23/postgresql-last-12-weeks-of-a-year/", "published_at": "2009-07-23T19:00:50+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e24675d311b", "title": "Hierarchial queries in MySQL: identifying trees", "url": "https://explainextended.com/2009/07/22/hierarchial-queries-in-mysql-identifying-trees/", "published_at": "2009-07-22T19:00:05+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e246842f8c8", "title": "PostgreSQL: round-robin order", "url": "https://explainextended.com/2009/07/21/postgresql-round-robin-records/", "published_at": "2009-07-21T19:00:35+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e24690223f6", "title": "Hierarchical data in MySQL: parents and children in one query", "url": "https://explainextended.com/2009/07/20/hierarchical-data-in-mysql-parents-and-children-in-one-query/", "published_at": "2009-07-20T19:00:47+00:00" }, { "id": "01a0c595-3fa1-70c5-b1e2-4e246988a178", "title": "PostgreSQL 8.4: sampling random rows", "url": "https://explainextended.com/2009/07/18/postgresql-8-4-sampling-random-rows/", "published_at": "2009-07-18T19:00:15+00:00" } ] posts Claim your blog
Back to explainextended.com
Blog · corpus.blog/blogs/explainextended.com/posts

explainextended.com

explainextended.com

2009

Shuffling rows: PostgreSQLoriginal ↗
6 Oct 2009
Date range with possible NULL valuesoriginal ↗
5 Oct 2009
Bitwise operations and indexesoriginal ↗
1 Oct 2009
IN vs. JOIN vs. EXISTS: Oracleoriginal ↗
30 Sept 2009
Adjacency list vs. nested sets: MySQLoriginal ↗
29 Sept 2009
Adjacency list vs. nested sets: Oracleoriginal ↗
28 Sept 2009
Adjacency list vs. nested sets: SQL Serveroriginal ↗
25 Sept 2009
Adjacency list vs. nested sets: PostgreSQLoriginal ↗
24 Sept 2009
Building alphabetical indexoriginal ↗
23 Sept 2009
Finding sets within a time frameoriginal ↗
22 Sept 2009
Rounding numbers preserving their sumoriginal ↗
21 Sept 2009
NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQLoriginal ↗
18 Sept 2009
NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: Oracleoriginal ↗
17 Sept 2009
NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: PostgreSQLoriginal ↗
16 Sept 2009
NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: SQL Serveroriginal ↗
15 Sept 2009
MySQL: emulating ROW_NUMBER with multiple ORDER BY conditionsoriginal ↗
14 Sept 2009
SQL Server 2005: finding foreign keys that have no indexoriginal ↗
10 Sept 2009
Oracle: generating a list of dates and counting ranges for each dateoriginal ↗
9 Sept 2009
MySQL: matching whole setsoriginal ↗
8 Sept 2009
PostgreSQL: selecting items that belong to all categoriesoriginal ↗
25 Aug 2009
SQL Server: leading wildcard match using an indexoriginal ↗
24 Aug 2009
What is a relational database?original ↗
23 Aug 2009
SQL Server: finding date closest to a birthdateoriginal ↗
21 Aug 2009
SQL Server: efficient DISTINCT on datesoriginal ↗
20 Aug 2009
MySQL: difference between setsoriginal ↗
19 Aug 2009
Passing parameters in MySQL: IN list vs. temporary tableoriginal ↗
18 Aug 2009
Hierarchical queries in MySQL: VARCHAR keysoriginal ↗
17 Aug 2009
Presentation layeroriginal ↗
16 Aug 2009
Oracle: updating rows with partitioned incremental valueoriginal ↗
12 Aug 2009
Efficient date range query: SQL Serveroriginal ↗
11 Aug 2009
Fallback language names: MySQLoriginal ↗
10 Aug 2009
Fallback language names: PostgreSQLoriginal ↗
8 Aug 2009
Fallback language names: SQL Serveroriginal ↗
7 Aug 2009
Fallback language names: Oracleoriginal ↗
6 Aug 2009
MySQL: LIMIT on LIMIToriginal ↗
5 Aug 2009
SQL Server: deleting adjacent values (improved)original ↗
4 Aug 2009
SQL Server: deleting adjacent valuesoriginal ↗
3 Aug 2009
MySQL: DISTINCT on DISTINCToriginal ↗
1 Aug 2009
MySQL: counting items in pairsoriginal ↗
31 Jul 2009
PostgreSQL: making duplicate records uniqueoriginal ↗
30 Jul 2009
PostgreSQL 8.4: efficient MIN(COUNT(*))original ↗
29 Jul 2009
SQL Server: random records avoiding CTE reevaluationoriginal ↗
28 Jul 2009
Dynamic pivotoriginal ↗
27 Jul 2009
MySQL: selecting rows before and after filtered oneoriginal ↗
25 Jul 2009
MySQL: grouping continuous rangesoriginal ↗
24 Jul 2009
PostgreSQL: last 12 weeks of a yearoriginal ↗
23 Jul 2009
Hierarchial queries in MySQL: identifying treesoriginal ↗
22 Jul 2009
PostgreSQL: round-robin orderoriginal ↗
21 Jul 2009
Hierarchical data in MySQL: parents and children in one queryoriginal ↗
20 Jul 2009
PostgreSQL 8.4: sampling random rowsoriginal ↗
18 Jul 2009
Previous