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

Tag: data-integrity

Diffrences between master and slave replication in mysql?

By adminPosted on January 10, 2023

Question : In a database named asterisk, there is a table named cdr which was partitioned on the time field. […]

How to conduct integrity test on SQL Server database backup file?

By adminPosted on December 16, 2022

Question : I was assigned to check the integrity of database backups from sql server every two weeks. I’m new […]

Use of log_bin_trust_function_creators in MySQL

By adminPosted on December 6, 2022

Question : What is the use of log_bin_trust_function_creators? Also, Is the value of the parameter dynamic? Will it change if […]

How can I enforce data integrity in this model with a M:2 relationship?

By adminPosted on December 2, 2022

Question : This model describes a part of my database (somewhat simplified): A “Tumor model” describes an experiment a researcher […]

How to add a check constraint in Postgres without locking the table?

By adminPosted on September 30, 2022

Question : I would like to add a check constraint to a very large table. Something like: ALTER TABLE “accounts” […]

How do I store phone numbers in PostgreSQL?

By adminPosted on September 26, 2022

Question : Let’s assume I want to store phone numbers in a database. I may accept phone numbers from outside […]

How do I ensure consistent MySQL backups?

By adminPosted on September 7, 2022

Question : How can we ensure MySQL backups are consistent when they are taken as full backups as well as […]

Constraining data based on related data in a different table. Should this be done on the database level or the application level?

By adminPosted on August 21, 2022

Question : I am working on a database that contains our customer information as well as information about our vendors. […]

how I can create check sum to validate no changes at int string pairs on table

By adminPosted on May 17, 2022

Question : Business case is. 1)Users print document on paper 2)users carry printed paper to Boss, Boss sing on paper […]

Best approach to compare specific columns of 2 tables in different databases?

By adminPosted on March 16, 2022

Question : I’m running an application who does have a shorten version of a table in the backend database. Both […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • INSERT array elements from JSON object as table rows
  • Table design for efficiently retrieving “most recent row” per FK’d item whose PK is a GUID
  • Why does my BETWEEN predicate not match any rows? [closed]
  • MySQL using a index referencing a different column
  • mysql – Recovering databases from ibdata1 , .frm and .idb
  • Postgres: What could cause the error “cannot call populate_composite on a scalar”?
  • Safely changing innodb_buffer_pool_size on MySQL replication master?
  • Why my index don’t update?
  • MySQL – What exactly does smallint(2) permit? [duplicate]
  • Optimize a slow nested loops join
  • How to perform query operation on another query result
  • Identity column re-seed: when it is necessary?
  • MySQL -> Loop through a table, running a stored procedure on each entry
  • Optimize Postgresql query
  • How to speed up mysql query?
  • How to optimize a query for < operator
  • SQL Server transaction log [duplicate]
  • Can’t do a full backup because the log is full [duplicate]
  • Mysql error : Slave SQL Could not execute …on table
  • mySQL changing output unit of ST_Distance function

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