Question : I have a tricky bit of SQL that’s giving me a bit of trouble. I’d like to introduce […]
Author: admin
Could once `max_standby_archive_delay` and `max_standby_streaming_delay` with value -1 can cause replication stop on heavy loads?
Question : In my replication servers on a postgresql master-slave replication scheme on aws RDS I get the following error: […]
How to group records by a two-value column ignoring small gaps?
Question : I have a subquery with a column named code that only has 1 and 0 values and an […]
MySQL nested queries
Question : I’m working on a project using a MySQL database and we’d like to combine a query which was […]
SQL Server Agent & sp_send_dbmail failing on permissions
Question : I have set up a SQL Server Agent job to call sp_send_dbmail with a very simple select on […]
Optimizing a query so MySQL will use the indexes for the joins
Question : Some context: migrating some data from a 3rd party cloud MongoDB platform service into MySQL. Wrote a query […]
Creating a read only replica of SQL Server database for reports
Question : I’ve faced a problem when my .Net web application is running slow, even when I’ve optimized all queries. […]
Why not nested schemas in PostgreSQL? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Optimising plans with XML readers
Question : Executing the query from here to pull the deadlock events out of the default extended events session SELECT […]
How to deconstruct a JSONB object
Question : In a PG10 database, I have a table called ToDos where I have defined a jsonb field called […]