Question : Given the following statement on the AdventureWorks database: UPDATE Sales.SalesOrderDetail SET OrderQty = 100 WHERE ModifiedDate >= ‘2014-01-01’ […]
Tag: concurrency
Sporadic Gap-lock related Deadlocks under high concurrency in MySQL 5.7
Question : Under high concurrency when running a daily process overnight we see deadlocks occur on a particular table, which […]
Contention on tempdb due to high concurrency temp table creation from multiple databases?
Question : I have an environment with ~100 databases, all with the same schema. There is a stored procedure on […]
Dirty read or phantom row
Question : We are having dirty reads or phantom rows in our data warehouse. My question is not how to […]
Can UPDATE lead to deadlocks in SQL SERVER?
Question : Can we experience deadlock if run the same update query concurrently? Let’s assume there’s a table with millions […]
Can’t update trigger because of activity
Question : Trying to add a line to a trigger that is attached to a table that is constantly in […]
Are lost updates completely handled in SQL Server or is manual intervention still required?
Question : As lost updates occur when 2 different transaction try to update the same thing at the same time […]
How to execute two transactions concurrently in PostgreSQL?
Question : I want to execute two transactions concurrently in pgAdmin: –The first transaction should modify the age of Paul […]
What happens when we add an index to an existing table with a large amount of data?
Question : I’ve a table which will contain around ~15 Million records. Now I need to add an index to […]
File database vs application server database for concurrent performance & bulk data
Question : I asked a question about Ripple’s database implementation, and received this response: The ripple server uses SQLite for […]