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

Tag: migration

creating new table partition with values already existing in the default partition

By adminPosted on January 30, 2023

Question : I have the following table: CREATE TABLE orders ( info_date date, country_code VARCHAR, order_total int, CONSTRAINT orders_pk PRIMARY […]

InnoDB: Cannot close file ./tablefile.ibd because of 1 pending operations

By adminPosted on January 30, 2023

Question : MariaDB Version: ‘10.5.13-9 I am facing multiple unsuccessful data migration(Copy) attempts from my old legacy data environment to […]

Transformation of row data based on a grouping of rows preceding it

By adminPosted on January 27, 2023

Question : The basis for this question is: Transformation of row data based on preceding row for special cumulative sum […]

AlwaysON Migrate from 2014 to 2016

By adminPosted on January 22, 2023

Question : I have like 20 Listners on 2014 with approx 500 DBS, what is the best way to migrate […]

Migrate SQL server data to new schema

By adminPosted on January 22, 2023

Question : I have a database that was originally created by a couple of people for a small business unit […]

SQL Server MDF still has old values after update

By adminPosted on January 22, 2023

Question : Let me start off saying I am not a DBA. My company is in the process of moving […]

Why do I get ERROR 1824 (HY000) while importing MySQL dump from 5.7 to 8.0.x?

By adminPosted on January 21, 2023

Question : I have a MySQL 5.7.x dump with about 12GB that I try to import into a newly installed […]

Looking for suggestions to Migrate Amazon RDS Large Instance to non-amazon host – Live

By adminPosted on January 17, 2023

Question : We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated […]

How to do a SQL Server 2016 continuous upgrade

By adminPosted on January 12, 2023

Question : I watched this channel9 video, and it mentioned you could now do a continuous upgrade to MS SQL […]

Syncing Database for Server Transition

By adminPosted on January 9, 2023

Question : I’m transitioning from an old web/sql box combined to a much more robust solution on a completely different […]

  • 1
  • 2
  • 3
  • …
  • 49

Recent Posts

  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger
  • How do I get the difference in minutes from 2 timestamp columns?

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