Search: [SQL] - Anayrat links

Missing Data - Joe Celko

SQL · celko

September 8, 2017 at 22:59:11 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/t-sql-programming/missing-data/

Graph Algorithms in a Database: Recursive CTEs and Topological Sort with Postgres

PostgreSQL · SQL · CTE

September 4, 2017 at 16:06:40 GMT+2 * · permalink

https://www.fusionbox.com/blog/detail/graph-algorithms-in-a-database-recursive-ctes-and-topological-sort-with-postgres/620/

Du nouveau dans les triggers avec PostgreSQL 10

PostgreSQL · Trigger · SQL

September 1, 2017 at 17:07:27 GMT+2 * · permalink

http://blog-postgresql.verite.pro/2017/09/01/triggers-postgresql-10.html

JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage – Java, SQL and jOOQ.

SQL · MySQL · Oracle · MSQLServer · DB2 · PostgreSQL · Performance

September 1, 2017 at 17:00:25 GMT+2 * · permalink

https://blog.jooq.org/2017/09/01/join-elimination-an-essential-optimiser-feature-for-advanced-sql-usage/

SQL Code Smells - Simple Talk

SQL · tuning · Tricks

August 31, 2017 at 19:11:27 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-code-smells/

Deferrable SQL Constraints in Depth

PostgreSQL · SQL · constraint · deferrable

August 27, 2017 at 18:20:28 GMT+2 * · permalink

https://begriffs.com/posts/2017-08-27-deferrable-sql-constraints.html

Oracle Database - Star Transformation [Gerardnico]

Oracle · SQL · Star_transformation · Star_schema · not_read · Datawarehouse

August 18, 2017 at 19:15:57 GMT+2 * · permalink

https://gerardnico.com/wiki/database/oracle/star_transformation

Star Optimization Evolution :: Chapter 5. Tuning Ad-Hoc Queries :: Oracle DBA guide to data warehousing and star schemas :: SQL :: eTutorials.org

Oracle · SQL · Star_transformation · Star_schema · not_read · Datawarehouse

August 18, 2017 at 19:14:54 GMT+2 * · permalink

http://etutorials.org/SQL/oracle+dba+guide+to+data+warehousing+and+star+schemas/Chapter+5.+Tuning+Ad-Hoc+Queries/Star+Optimization+Evolution/

Star Transformation | Oracle Scratchpad

Oracle · SQL · Star_transformation · Star_schema · not_read · Datawarehouse

August 18, 2017 at 19:13:33 GMT+2 * · permalink

https://jonathanlewis.wordpress.com/2011/04/22/star-transformation/

SSI/fr - PostgreSQL wiki

PostgreSQL · SQL · Isolation

August 18, 2017 at 16:13:29 GMT+2 * · permalink

https://wiki.postgresql.org/wiki/SSI/fr

Regular Expressions and Grouping Sets

PostgreSQL · SQL

August 14, 2017 at 20:47:34 GMT+2 * · permalink

http://tapoueh.org/blog/2017/08/regular-expressions-and-grouping-sets/

Simple SQL: Random Thoughts - Joe Celko

SQL

August 11, 2017 at 22:07:33 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/t-sql-programming/simple-sql-random-thoughts/

Mapping Oracle to PostgreSQL data types | OpenSCG

PostgreSQL · Oracle · SQL

August 11, 2017 at 08:51:15 GMT+2 * · permalink

https://www.openscg.com/2017/08/mapping-oracle-to-postgresql-data-types/

Principles of Sharding for Relational Databases

PostgreSQL · SQL · Sharding

August 10, 2017 at 19:32:42 GMT+2 * · permalink

https://www.citusdata.com/blog/2017/08/09/principles-of-sharding-for-relational-databases/

Fixing foreign key deadlocks, part three – Command Prompt, Inc.

PostgreSQL · SQL · Isolation · not_read

August 10, 2017 at 11:00:24 GMT+2 * · permalink

https://www.commandprompt.com/blog/fixing_foreign_key_deadlocks_part_three/

9 Reasons Why There Are No Foreign Keys in Your Database (Referential Integrity Checks)

SQL

August 9, 2017 at 17:00:27 GMT+2 * · permalink

https://dataedo.com/blog/why-there-are-no-foreign-keys-in-your-database-referential-integrity-checks

SQL Regression Tests

PostgreSQL · SQL

August 9, 2017 at 14:10:09 GMT+2 * · permalink

http://tapoueh.org/blog/2017/08/sql-regression-tests/

Practical Guide to SQL Transaction Isolation

SQL · PostgreSQL · Isolation

August 2, 2017 at 14:35:22 GMT+2 * · permalink

https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html

Average response time with Postgres’ Window Functions and CTEs

PostgreSQL · CTE · SQL

July 31, 2017 at 14:16:09 GMT+2 * · permalink

https://medium.com/@chamini2/average-response-time-with-postgres-window-functions-and-ctes-a19adb7ed4f7

18+ Best Online Resources for Learning SQL and Database Concepts

SQL

July 29, 2017 at 15:56:16 GMT+2 * · permalink

https://academy.vertabelo.com/blog/18-best-online-resources-for-learning-sql-and-database-concepts/