List/Grid Tag Archives: SQL
Logging Hibernate SQL
There are two well-known ways to log Hibernate SQL in Grails; one is to add logSql = true in DataSource.groovy (either in the top-level block for all environments or per-environment) dataSource ...
SQL tooling, the ranking
When you need to get up and running quickly with your database, the tooling becomes very important. When developing jOOQ and adding integrations for new databases, I really love those ...
Arcane magic with the SQL:2003 MERGE statement
Every now and then, we feel awkward about having to distinguish INSERT from UPDATE for any of the following reasons:We have to issue at least two statements We have to think about ...
GROUP BY ROLLUP / CUBE
Every now and then, you come across a requirement that will bring you to your SQL limits. Many of us probably give up early and calculate stuff in Java / [or your language]. Instead, ...
Add APPLY to Your TSQL Tool Belt
Every once in a while I stumble across some SQL keyword that I didn’t really know about, but is extremely useful. The other day I came across APPLY, or rather CROSS APPLY. After reading ...
