Is using JOINs to avoid numerical IDs a bad thing?
66324
Performance of string comparison vs int join in SQL
63366
Guid vs INT - Which is better as a primary key?
8316
Do frequent DML operations on a table with indexes and huge data affect SELECT query performance?
107938
How to handle fragmentation of auto_increment ID column in MySQL
148559
Using the correct, or preferable, not equal operator in MySQL
115199
In what order are MySQL JOINs evaluated?
5515
Benefits of using backtick (`) in MySQL queries?
16178
SQL JOIN - WHERE clause vs. ON clause
75366
Why is SELECT * considered harmful?
3262
How to deal with SQL column names that look like SQL keywords?
40249
How to use mysql JOIN without ON condition?
131058
Decision between storing lookup table id's or pure data
39592
Are there disadvantages to using VARCHAR(MAX) in a table?
143056
Can I use set instead of List to resolve the duplicate id issue
1017
Is MySql's LAST_INSERT_ID() function guaranteed to be correct?
41314
Is there a REAL performance difference between INT and VARCHAR primary keys?
30567
Is it appropriate to down-vote posts containing SQL injection vulnerabilities?