/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 blog.jooq.org
How to Write a Multiplication Aggregate Function in SQL Java, SQL and jOOQ.
| | www.adamconrad.dev
Data models and query languages - Adam C. Conrad
14.6 parsecs away

Travel
| | Ch 2 of my book club review of Designing Data-Intensive Applications by Martin Kleppmann.
| | nenadnoveljic.com
Performance Problem with Incremental Statistics Calculation - All-round Database Topics
14.3 parsecs away

Travel
| | A frequently executed SQL causes problems with the initial incremental statistics calculation.
| | modern-sql.com
SQL LISTAGG concatenates values of multiple rows into an delimited string such as CSV.
9.7 parsecs away

Travel
| | LISTAGG is the new SQL standard version of GROUP_CONCAT or STRING_AGG. LISTAGG supports DISTINCT and provides an ON OVERFLOW clause to control the behavior when exceeding the maximum string length.
| | schottsql.com
SQL Shades for SQL Management Studio - Review
37.8 parsecs away

Travel
| For those of us who've worked with SQL Server for some time, we've regularly used SQL Server Management Studio (SSMS). In recent years, we've seen an increase in websites and appl...