Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.
user avatar
user avatar
user avatar
TRiG
  • Member for 10 years, 9 months
  • Last seen this week
102 votes
18 answers
37k views

Is adding the ‘tbl’ prefix to table names really a problem?

53 votes
7 answers
173k views

In what data type should I store an email address in database?

150 votes
12 answers
94k views

Should binary files be stored in the database?

32 votes
3 answers
23k views

Why is it recommended to store BLOBs in separate SQL Server tables?

25 votes
4 answers
6k views

If NoSQL stands for "Not only SQL", is SQL a subset of NoSQL?

8 votes
3 answers
1k views

How to treat numbers within strings as numbers when sorting ("A3" sorts before "A10", not after)

8 votes
3 answers
17k views

Why is my MySQL dump file and my phpMyadmin export file different sizes?

24 votes
12 answers
9k views

Why are constraints applied in the database rather than the code?

2 votes
3 answers
76 views

How can I design a relational database with words that are all related to each other

18 votes
2 answers
4k views

Why does SQL Injection not happen on this query inside a stored procedure?

10 votes
3 answers
5k views

Users complain that system runs slow when mysqldump is in progress

200 votes
7 answers
266k views

How can I optimize a mysqldump of a large database?

31 votes
4 answers
16k views

Is it bad to have index space larger than data space?

52 votes
2 answers
11k views

Is it a bad practice to have several mutually exclusive one-to-one relationships?

0 votes
2 answers
2k views

Why are there different Database Collations for different languages? [closed]

5 votes
2 answers
7k views

Why not use SQL_Latin1_General_CI_AS for a global system?

4 votes
1 answer
930 views

Howto find out details and reasons for idle transactions?

8 votes
3 answers
35k views

SQL Server Collation for Arabic, Hebrew, English and French

25 votes
3 answers
5k views

Which collation should I choose for a muiti-language website?

3 votes
2 answers
17k views

What is the difference between NULL and \N while loading data from a csv using load data local infile

6 votes
3 answers
3k views

Why are there different levels of MySQL collation/charsets?