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

Tag: database-design

optimize design for a table with 50 columns [closed]

By adminPosted on March 26, 2023

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

Efficient way to store multi choice in a column with few options

By adminPosted on March 26, 2023

Question : I am looking for advices on how to handle multiple choices in a column? By way of example […]

Handling of Topic Drill Downs in Databases

By adminPosted on March 26, 2023

Question : I have a requirement wherein I have to set up a drill down feature. For example: There is […]

How to link other tables (entities) to parent and child categories?

By adminPosted on March 26, 2023

Question : I am not a developer by any means, but I have a fairly good understanding of how relational […]

MYSQL Indexes when looking up on alternating sets of columns

By adminPosted on March 25, 2023

Question : I have a table that looks like: CREATE TABLE `connections` ( `connection_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `service_id` […]

Creating Database Tables for Reviews functionality that incorporates Tags/Categories

By adminPosted on March 25, 2023

Question : I’m wanting to create some simple website functionality through a little database idea I have in order to […]

Are there situations where queries are formed geometrically?

By adminPosted on March 25, 2023

Question : The topic came up in this other question. We were discussing sign value on a primary key having […]

Database structure for product attributes on orders

By adminPosted on March 25, 2023

Question : I’m making a POS and currently kind of stuck on the order proccess due to the product attributes. […]

Every “INSERT” query check a combination of column’s records

By adminPosted on March 25, 2023

Question : Unfortunately, my mind has stacked right now and i would like to design a really simple DB schema. […]

How to design SQL schema that treats historical data as first-class citizen?

By adminPosted on March 25, 2023

Question : I’m currently designing a SQL Server database schema for an application that consists of highly structured “tree” data. […]

  • 1
  • 2
  • 3
  • …
  • 580

Recent Posts

  • Logins aren’t syncing across Availability Groups
  • Finding same values and updating rankings
  • Servers running on Microsoft Windows instead output carriage
  • Master ip has changed in postgresql replication
  • optimize design for a table with 50 columns [closed]
  • SQLServer In-Memory database and log file size unexpected increase
  • Is it worth to optimize queries with EarlyTermination Timeout?
  • Is there way to get transaction commit timestamp in Postgres?
  • MySQL/PHP Returning Blank Error Message [closed]
  • Mysql might have too many indexes
  • Database replication with ability to revert to previous states
  • Linked server to Oracle doesn’t use filters. Are there any performance changes in different versions of SQL Server?
  • Enable query store for all databases
  • SQL Server 2012 Enforce Password Policy [closed]
  • Maintenance in MYSQL when innodb_file_per_table disabled
  • SQL Server stored procedure producing data related to months between two dates [duplicate]
  • Efficient way to store multi choice in a column with few options
  • Need help tuning my.cnf file
  • Insert and select the row autoincremented id
  • Use “LEN” function in “WHERE” clause in “CREATE UNIQUE INDEX”

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