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

Tag: delete

All data got deleted or truncated- What happened?

By adminPosted on September 16, 2023

Question : What are some of the ways of knowing how the 100 M rows of record table got wiped […]

How do I force the delete of users from my database?

By adminPosted on September 8, 2023

Question : I am making a clean backup of our development database for easy fresh spin-ups of the database. This […]

Why doesn’t a delete increase unused space in a table?

By adminPosted on August 28, 2023

Question : If I populate the following table: IF OBJECT_ID (‘dbo.CleanTableTest’, ‘U’) IS NOT NULL DROP TABLE dbo.CleanTableTest; GO CREATE […]

Do I need to reindex mysql table after bulk delete?

By adminPosted on August 23, 2023

Question : I have a table in MySQL with a lot of INSERT and SELECT at every second. And there […]

Postgres 9.3 – deletes terribly slow for 10 minutes after dropping indexes/constraints

By adminPosted on August 20, 2023

Question : If I run a script which drops indexes (17 of them, CONCURRENTLY makes no difference except that without […]

remove duplicate rows in mysql table that does not contain primary key

By adminPosted on August 15, 2023

Question : I have a table item having just one column name:- name —– toys shirt mobile Shirt speaker Toys […]

Cannot perform SELECT COUNT(*), rows over 1 billion on a table

By adminPosted on August 13, 2023

Question : I have this table that contains over a billion rows and to issue the query, I issued: SELECT […]

Deleting rows from child table without deleting from parent [closed]

By adminPosted on August 6, 2023

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

How to delete large amount of data in sql server without data loss?

By adminPosted on August 6, 2023

Question : I’ve been dealing with million of data deletion in day to day process. Basically I have 4 tables. […]

Delete all records in tables with reference to another reference

By adminPosted on July 24, 2023

Question : Sorry if the title to this question makes no sense. I really wasn’t sure how else to word […]

  • 1
  • 2
  • 3
  • …
  • 33

Recent Posts

  • ObjID in Page Header
  • Applying data changes from one database to another
  • postgresql won’t install dependencies
  • T-SQL query to show table definition of sys.time_zone_info
  • What is using all my space?
  • Large ibdata file in MySQL
  • What exactly are secondary members acknowledging in replicasets with MongoDB?
  • How to access user information via sys.fn_dump_dblog
  • Instance Startup Modes & Shutdown Modes
  • INT(5) vs SMALLINT(5): numbers in parenthesis after the numeric type
  • Restarting primary SQL Server instance with log shipping
  • Fastest way to change a 600GB table indexed key datatype from INT to BIGINT
  • ) c
  • SQL Job runs without it schedule and renaming or deleting it causes other jobs fail
  • mysql emits BINLOG rows even though binlog_­format=­STATEMENT
  • Which mechanism is best for previous data archived in oracle?
  • How large will a MySQL database be relative to the dump file?
  • DBClientCursor::init call() failed
  • Very slow query on table with Blob column [closed]
  • Batch query a lot of MySQLdump files

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