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

Tag: rollback

Find history of rollbacks on SQL Server 2012 [duplicate]

By adminPosted on January 12, 2023

Question : This question already has answers here: Get transactions that failed or were never committed (3 answers) Closed 5 […]

after executing a back up cmd (via query) how to kill it

By adminPosted on December 30, 2022

Question : I have a big database (150 GB) that needs a back up and I don’t have space in […]

Rollback parent procedure on failure in MySQL

By adminPosted on December 18, 2022

Question : I have the following two procedures on my server: CREATE DEFINER=`someone`@`localhost` PROCEDURE `NewMagnet`( IN `nick` VARCHAR(32), IN `tth` […]

How to recover auto committed transaction in Oracle with normal privilage

By adminPosted on December 13, 2022

Question : I have updated the table & need to rollback that changes. I have tried Rollback work command but […]

Dependent Transaction in separate Database-Connections

By adminPosted on November 26, 2022

Question : I am quite new to database and I am in the following situation. I have two tables defining […]

How to configure read transactions to never cause other write serialization transactions to fail

By adminPosted on November 17, 2022

Question : I am protecting critical transactions with application mutexes and SERIALIZABLE. I presume that this makes these operations as […]

Delete statement not responding to Kill session command

By adminPosted on October 29, 2022

Question : Four days ago a user ran the command below on a table with 400,000,000 rows. It’s still running […]

Rollback of ALTER TABLE ALTER COLUMN command taking forever

By adminPosted on October 15, 2022

Question : I have a very large table that needed a schema change to one column – I needed to […]

Truncating and inserting in a safe transaction on MySQL

By adminPosted on October 5, 2022

Question : I am trying to TRUNCATE and INSERT data into a MySQL InnoDB table. I wanted to make sure […]

Transactional DDL workflow for MySQL

By adminPosted on September 30, 2022

Question : I was a little surprised to discover that DDL statements (alter table, create index etc) implicitly commit the […]

  • 1
  • 2
  • 3
  • …
  • 7

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