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

Tag: design-pattern

Composite Primary Key in multi-tenant SQL Server database

By adminPosted on January 20, 2023

Question : I’m building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure […]

Why would an application use one central metadata table to hold metadata for all other tables?

By adminPosted on December 3, 2022

Question : I’ve started working with an application that has an usual design: In addition to the tables that contain […]

If the query for database too complicated, does it means the design of Database is bad?

By adminPosted on November 4, 2022

Question : I am new to database, and below is one of my query with it’s explanation, I feel it’s […]

Most efficient ordering post database design

By adminPosted on August 13, 2022

Question : I have posts table that is has post_order column. I store order of each post in it. when […]

Composite Primary Key in multi-tenant SQL Server database

By adminPosted on July 4, 2022

Question : I’m building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure […]

Numerical data with lots of NULLs: 6NF or document database?

By adminPosted on June 23, 2022

Question : I have a source of numerical data mostly comprised of sensor readings, physical quantities and flags. Each associated […]

Pair of 2-tuple composite FKs pointing to same table (closure table pattern)

By adminPosted on May 31, 2022July 1, 2022

Question : I don’t have much experience with DB design, and having a hard time figuring out what’s wrong with […]

Which postgres design for a nested resource that can link to the same type of resource

By adminPosted on May 8, 2022

Question : I have this kind of data that I need to store in postgres (ruby object). #<InitRes:0x007f8ec3734c78 @kind=”RestrictionsSchema”, @restrictions= […]

Time Series Table ( Many Columns ) Design Recommendations [duplicate]

By adminPosted on May 4, 2022

Question : This question already has answers here: How to store many smallish time-series in a relational DB? (3 answers) […]

Numerical data with lots of NULLs: 6NF or document database?

By adminPosted on May 3, 2022

Question : I have a source of numerical data mostly comprised of sensor readings, physical quantities and flags. Each associated […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Inner procedure is rolled back but outer procedure is still committed
  • Is there a better way to add failed node back to postgres cluster?
  • How can I create a role to create,update,delete stored procedures and views
  • Is ASYNC_NETWORK_IO wait type anything to worry about?
  • Logical optimization of joins and selections
  • Is it possible to install Developer Edition of SQL Server as the primary development server?
  • Is “deadlock detected” really an error? Should I be suppressing them after handling them?
  • Backup not creating a new file
  • Locking issue with concurrent DELETE / INSERT in PostgreSQL
  • Does InnoDB store row counts in secondary index B-Tree non-leaf nodes?
  • Insert multiples rows/columns – PostgreSQL 9.2
  • Test if any columns are NULL
  • Profiling a PostgreSQL function [duplicate]
  • Why is MySQL database data-files deployed under /var/lib/mysql?
  • postgres finding child tables for particular table
  • InnoDB row metadata size (minimum row size)
  • Restoring SQL Server Database Command Line Error
  • Wrong sharding on mongoDB 3.0
  • how can I join two very different table structures? No common keys
  • How to get next value of Sequence dynamically in Oracle

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