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

Tag: delete

Aggresive indexes lead to lock times

By adminPosted on November 23, 2022

Question : Using sp_blitzindex from Brent Ozar, I found this particular problem. The table(s) – (there are many of them, […]

Full table scan – high water mark

By adminPosted on November 23, 2022

Question : When doing a full-table scan, why does Oracle scan all the rows beneath the high-water mark? Doesn’t it […]

Best way to delete large set of rows knowing field to NOT delete

By adminPosted on November 14, 2022

Question : Coming from a Rails background, I have a large production database that I have a copy of where […]

Disk file effects of delete and vacuum

By adminPosted on November 13, 2022

Question : I have a very frequently updated table with 240 million rows (and growing). Every three hours 1.5 million […]

Unable to delete a record in Mysql

By adminPosted on November 12, 2022

Question : Let’s say I have table name Company with two columns cname, location. In the table I am having […]

Methods of speeding up a huge DELETE FROM with no clauses
By adminPosted on November 11, 2022July 1, 2022

Question : Using SQL Server 2005. I am performing a huge DELETE FROM with no where clauses. It’s basically equivalent […]

Sql Server Transaction logs during large deletes

By adminPosted on November 2, 2022

Question : At my work, I am going to be moving millions of records to a different server, and removing […]

Delete entry from related tables

By adminPosted on October 29, 2022

Question : I can not use InnoDB engine because of some dependency troubles in LuaSQL and PtokaX. My current query […]

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

How to delete data from both tables or least one of them, when using “delete from … using … where” in Postgresql?

By adminPosted on October 27, 2022

Question : I have this sql script for my Postgresql db: DELETE FROM table1 USING table2 WHERE table2.frg_table1_id = table1.id […]

  • 1
  • 2
  • 3
  • …
  • 26

Recent Posts

  • Nested CTEs Returning Incorrect Results in Certain Situations
  • SQL Server Express to SQL Server Standard upgrade?
  • SQL server disk write queue dramatically grows sometimes
  • some tips on setting up sql server database server
  • SELECT + INSERT or INSERT alone
  • How to grant only functions while revoking tables?
  • Hiring a database Dev
  • Regarding create index and lock word in SQL statement used for SQL Server
  • SQL command or trigger needed to capture changes in tables [duplicate]
  • backup a specific set of tables to be moved to a remote system [duplicate]
  • inconsistent type after querying search_condition column in all_constraints table Oracle
  • How to kill a stored procedure which is in open transaction?
  • Is there a generic framework/design pattern/library for real time replication of MySQL database onto other servers?
  • Any advantages if we use multiple database instead of only one in PostgreSQL?
  • how to count specific product in sql table
  • Dependent Transaction in separate Database-Connections
  • Why does PostgreSQL keep resetting my date to the wrong “timezone”, with “seconds”, as I try to remove it?
  • autogrowth set higher than available disk
  • Inline edit SQL Server database rows from Visual Studio
  • MongoDB 3.6 crashed due to invariant() failure

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