user avatar
user avatar
user avatar
TRiG
  • Member for 10 years, 11 months
  • Last seen more than a month ago
201 votes
7 answers
270k views

How can I optimize a mysqldump of a large database?

  • 4,119
151 votes
12 answers
96k views

Should binary files be stored in the database?

  • 37.6k
102 votes
18 answers
37k views

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

  • 7,146
55 votes
7 answers
175k views

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

  • 1,338
52 votes
2 answers
11k views

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

32 votes
3 answers
24k views

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

  • 3,135
31 votes
4 answers
17k views

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

  • 441
25 votes
3 answers
5k views

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

  • 3,183
25 votes
4 answers
6k views

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

  • 455
24 votes
12 answers
9k views

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

  • 359
18 votes
2 answers
4k views

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

  • 657
10 votes
3 answers
5k views

Users complain that system runs slow when mysqldump is in progress

  • 176
8 votes
3 answers
35k views

SQL Server Collation for Arabic, Hebrew, English and French

8 votes
3 answers
17k views

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

8 votes
3 answers
2k views

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

6 votes
3 answers
3k views

Why are there different levels of MySQL collation/charsets?

  • 163
5 votes
2 answers
7k views

Why not use SQL_Latin1_General_CI_AS for a global system?

  • 203
4 votes
1 answer
966 views

Howto find out details and reasons for idle transactions?

  • 4,645
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

2 votes
3 answers
79 views

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

0 votes
2 answers
2k views

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

  • 19