Question : What are some of the ways of knowing how the 100 M rows of record table got wiped […]
Tag: delete
How do I force the delete of users from my database?
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?
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?
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
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
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
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]
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?
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
Question : Sorry if the title to this question makes no sense. I really wasn’t sure how else to word […]