Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Category: Database Design

Implementing something similar to “pointer arrays” with MySQL

By adminPosted on June 8, 2023

Question : While building a site I came across the following issue: I want to be able to have multiple […]

Database Design Table for forecasting

By adminPosted on June 7, 2023

Question : I am designing a database to mainly share data regarding projects and their progress. Part of this is […]

Use a set database schema or EAV design? [duplicate]

By adminPosted on June 7, 2023

Question : This question already has an answer here: To EAV or not to EAV? (1 answer) Closed 7 years […]

How to structure a database to show data for each USA State and Canada Territory on a Per user basis?

By adminPosted on June 7, 2023

Question : I need to build a PHP/MySQL application. I am a bit confused on how to do the database […]

Insertion of data violates the foreign key constraint

By adminPosted on June 6, 2023

Question : Consider I have two tables Employee and Department with the fields given below: Employee: Fname, Minit, Lname, Ssn […]

How to manage very large amount of data in mysql

By adminPosted on June 6, 2023

Question : I have a table in MySQL in which I write logs of users in a specified format. It […]

Standard naming for a credential systems

By adminPosted on June 6, 2023

Question : Is there a standard naming convention in regards to credential oriented systems? (Logins) The only one I could […]

Problem with compare value with its aggregate function within the same table

By adminPosted on June 6, 2023

Question : I need to find the list of customer_id for customer who have spent more than the average customer. […]

Best db setup to accomplish yes/no list of clients for daily calls

By adminPosted on June 6, 2023

Question : I will preface this by saying I am a relative novice to Access but I have managed to […]

How does one know when to stop normalizing?

By adminPosted on June 5, 2023

Question : Alright, so basically I feel that I tend to over-normalize things, and maybe I am doing it at […]

  • 1
  • 2
  • 3
  • …
  • 378

Recent Posts

  • Create a user on database A with a procedure from database B (with EXECUTE AS)
  • Mysql pivot rows
  • SQL Server CLR procedures and SQLCLR_QUANTUM_PUNISHMENT
  • backup history using availability groups
  • How to prevent database shrinking
  • postgres select aggregate timespans
  • mysql simple update with 40 million and 128GB RAM taking too much time
  • Suggestion for enforcing unique constraint in a table where soft delete is implemented [duplicate]
  • Implementing something similar to “pointer arrays” with MySQL
  • What are valid connection strings for SSMS login box?
  • ERROR 1114 (HY000) at line 6308 in file & The table user_analysis is full
  • Faulty oracle11g regexp_replace on removing duplicates
  • MySQL – Can I have quick queries in a table with 200 million rows?
  • Automatic index creation for primary vs. foreign keys in Postgresql
  • In PostgreSQL, how do I make it so that either column A or column B must be non-null?
  • Automate backup using Windows Task Scheduler
  • Naming Convention for Login, User and Roles? [closed]
  • Changing from utf8 to utf8mb4
  • How to get a COUNT for both IN and NOT IN a table
  • Database Design Table for forecasting

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding