Question : The most important table of my database is about 300,000 records, and growing. More than 20 tables have […]
DbaFix
Database for opening times of locations
Question : I’m designing a database for opening times and created this solution. The specifications of the database which will […]
Should I repeat UNIQUE constraint on similar multi-index?
Question : The index are on tuples, ordered sets, of columns, but the UNIQUE constraint or qualifiant for an index […]
MySQL #1054 – Unknown column ‘masterdata_hyung_event.eventId’ in ‘on clause’ on deep join tables
Question : So, I have this query SELECT * FROM hyung LEFT JOIN masterdata_hyung_description ON hyung.descriptionId = masterdata_hyung_description.hyungDescriptionId CROSS JOIN […]
Best way to associate multiple records with one another
Question : What is the best database design to associate multiple rows with another another. Let’s say we have a […]
Filter on array text[] and sort on timestamp
Question : Description PostgreSQL 9.6 on Linux, size of tags_tmp table ~ 30 GB (10 million rows), tags is a […]
Survey DB Design. No user answers, only questions
Question : The task is to SQL a bunch of surveys in order for the researchers to have examples for […]
Users complain that system runs slow when mysqldump is in progress
Question : The MYSQL database (ibdata1) is of size 73 GB and is configured to run as a dedicated database […]
Replacing Postgres User
Question : I’m new to postgres. It might sound a silly question, due to some security requirement I need to […]
Getting Max for partition column in clustered columnstore index
Question : SQL 2014 Enterprise I have a datawarehouse table with ~ 800 million rows (total table size ~25 GB) […]