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

Tag: rollback

Killed SPID on xp_LogInfo not rolling back and growing tempdb [duplicate]

By adminPosted on May 21, 2023

Question : This question already has answers here: How to identify which query is filling up the tempdb transaction log? […]

Keep local variable after rollback in mysql

By adminPosted on May 17, 2023

Question : I wish to keep local variable from stored procedure even if rollback occurres. In following procedure, i “register” […]

is it possible to rollback only a partition/subpartition?

By adminPosted on May 14, 2023

Question : Is it possible to create a savepoint and to rollback only a partition of a table? Lets assume […]

Implementing a Record Keeper/Rollback System for a MySQL Database

By adminPosted on April 23, 2023

Question : What’s the best way to create a record keeping table for all actions in my database? I have […]

Why did a SQL Server Restart roll-back seemingly committed transactions?

By adminPosted on April 3, 2023

Question : I am using SQL Server 2014 Express It seems that restarting SQL Server when an event such as […]

Copy a Large INNODB table in MySQL

By adminPosted on April 2, 2023

Question : I have an INNODB table that’s > 93 million rows. A lot of the data is considered “temp” […]

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 […]

  • 1
  • 2
  • 3
  • …
  • 7

Recent Posts

  • Avoid using Many to Many Relationship
  • Does MySQL still handle indexes in this way?
  • Microsoft SQL Server equivalent to Oracle Enterprise Manger Top Activity Interface?
  • Retrieve next queue item
  • Why does ENCODE on BYTEA not seem to have any performance impact?
  • Applying Multiple Window Functions in 1 SELECT using different partition
  • With SQL Server’s Query Store, how can cleanup avoid deleting “least expensive” queries?
  • PostgreSQL 11 fails to start if add `listen_addresses = ‘*’` in pg_hba.conf
  • Joining two tables with an alias
  • What is hot spotting in the context of adding files to tempdb?
  • 1822, “Failed to add the foreign key constraint. Missing index for constraint in referenced table script [closed]
  • MySQL – cannot examine view definition – Error getting DDL for object – No database selected
  • Database design for a lot of rows with data archive
  • Is the Service Broker good for publishing data between servers?
  • MySQL – query to show guests with same last_name + booking_date [closed]
  • How can primary keys in a Netezza table be indexed?
  • Is Oracle more demanding environment for a DBA than SQL Server? [closed]
  • Tiny table causes extreme performance degradation, fixed by forced VACUUM. Why?
  • Generating an arithmetic sequence
  • Find jobs that succeeded, but had steps that failed

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