Question : I am working on travelling app, where users can book online vehicles to travel. On the customer side […]
Author: admin
Hard Drive Configuration for my setup
Question : I have a fairly large transactional database (100GB) with a lot of users. The database access is solely […]
Optimize delete query in SQL Server 2008 R2 SP1
Question : I have a delete query which takes around 6 mins to complete. I am looking for ways to […]
Join query with closest date in “ON” clause
Question : I need to make an OUTER JOIN on two tables, based on 2 columns, first id an INTEGER […]
Postgresql vs MySQL – Which is better for join queries & writing data(inserts) [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Subtracting an integer in my db by 1. SQL
Question : I want to subtract the follower count of a user by 1, or increase it by but I […]
MariaDB Galera Arbitrator failing to sync with SSL
Question : So the scenario is this. I have already setup a 4 node MariaDB Galera cluster (10.5). I’m also […]
Array exceed allowed size in Postgres
Question : I have a function that accepts as parameter an array like: CREATE OR REPLACE FUNCTION my_func(some_data custom_datum[]) RETURNS […]
Mysql Server 5.6 high memory consumption
Question : I have a problem with my mySQL server. It consumes 9.7 GB ram. I have only a very […]
SQL Server 2016 Always ON high availability group listener configuration
Question : I have 2 servers running Windows Server 2016 with Microsoft SQL Server 2016 Enterprise. I have created a […]