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

Tag: non-deterministic

Why can’t I persist binary(4) computed column?

By adminPosted on August 2, 2023

Question : I’m playing with storing and indexing IP addresses. I’m starting with a simple, stupid table: CREATE TABLE [dbo].[IP_addresses]( […]

Non-deterministic functions and row-based binary logging (MySQL)

By adminPosted on January 24, 2022

Question : Newbie questions. I’m working on a MySQL project that will use only row-level binary logging. There will be […]

Recent Posts

  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency
  • Many-To-Many relationship between Students and heights (Is it necessary?)
  • What is the ideal composite index for this query?
  • hosting images on own database or 3rd party
  • Can’t start mongodb server using ‘sudo service mongod start’
  • sqlcmd new login/user
  • Log Reader replication agents are constantly restarting
  • NTFS filesystem fragmentation & other influence vs database files
  • How to set the grow rate of database in SQLserver
  • How to make a trigger that will compare input with a value of other table?

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