mdoyle's user avatar
mdoyle's user avatar
mdoyle's user avatar
mdoyle
  • Member for 11 years, 10 months
  • Last seen more than 1 year ago
16 votes

Why would SET ARITHABORT ON dramatically speed up a query?

15 votes
Accepted

Database Design Cars-Models / Car Classifieds

6 votes
Accepted

Update field with new string made from characters in existing value

5 votes
Accepted

unreachable SQL Server for a group of computers

5 votes
Accepted

Disabling "SHOW TABLES;" on mysql

5 votes
Accepted

Clustered composite key high fragmentation and fill factor

4 votes
Accepted

What is the advantage of using numeric primary keys in a relational database?

4 votes
Accepted

Identify why a user can drop a database

3 votes

Getting a "type" column from each table in query

3 votes
Accepted

JOIN 2 tables, and query data from them 3 times

3 votes
Accepted

Implementing voting system like reddit/StackExchange?

3 votes
Accepted

Boyce-Codd Normal Form

2 votes
Accepted

UK Addresses in 3NF

2 votes
Accepted

How to retrieve time in XML

2 votes
Accepted

How to design tables for players in a tournament?

2 votes

How to use keys in a table so two columns are unique

2 votes
Accepted

MySQL: SLEEP injection

2 votes

MySQL: Use Sysbench on Windows

1 vote

how to set a row's value from a certain row's value?

1 vote
Accepted

big db for managing user files and settings

1 vote

Best relational database structure for this data

1 vote
Accepted

MySQL Tables crashing randomly

1 vote

What is the best database design for this situation?

1 vote

Not able to create a new table new_table from t1 by comparing primary key values of another table t2 in MYSQL

1 vote
Accepted

What mongodb database layout would fit better

0 votes

Split date range into indiviual records

0 votes

Does this query make sense?

0 votes

Update Table A row if Table B row is changed