Willem Renzema's user avatar
Willem Renzema's user avatar
Willem Renzema's user avatar
Willem Renzema
  • Member for 10 years, 9 months
  • Last seen this week
2 votes
Accepted

Does ACID guarantee locking (semaphore) until the transaction is commited?

1 vote
Accepted

Division By 0 error when running an update query MySQL

-1 votes

How to avoid deadlocks when generating consecutive ticket numbers?

1 vote

MySQL optimizer won't use my index

0 votes
Accepted

Issue with Auto increment in MYSQL

0 votes
Accepted

Mysql Performance issue with millions rows and group by

3 votes

Mysql GROUP BY is really slow on a simple view

1 vote

MySQL query very slow with multiple concurrent users in a short time

1 vote

Constant deadlocks on a high load table

1 vote
Accepted

MySQL JOIN query takes too much time to get the result

2 votes

I need to remove duplicate values SQL Left Join

3 votes
Accepted

How to search one bible verse from a source that may contain ranges?

1 vote

MySQL query is taking a long time

3 votes
Accepted

How to have a "kinda" unique column

4 votes
Accepted

Cannot login in as root user after MySQL installation (RHEL)

0 votes
Accepted

Join Multiple Tables for Aggregates

3 votes
Accepted

Why does this MySQL query take 25+ seconds?

1 vote
Accepted

Why Output is wrong after doing the left join as subquery

0 votes
Accepted

Overly eager explicit row locking causes deadlock

0 votes

Performance issues with groupwise MAX in JOIN clause

5 votes
Accepted

Which columns should be indexed when all may be used in different search queries?

5 votes

Anyone understand why this query no longer works?

1 vote
Accepted

MySQL not using indexes

0 votes
Accepted

Trying to reduce number of table scans when querying on the same column but different values

3 votes
Accepted

I need help creating an index for timestamp

1 vote
Accepted

MySQL Varchar Primary Key With Not Null Constraint Accepting Nulls

1 vote

Normalizing data past initial db design phase

11 votes
Accepted

Is there a performance benefit to use tinyint instead of int for Primary Key?

19 votes
Accepted

Why does this query result in deadlock?

1 vote

How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?