user avatar
user avatar
user avatar
TRiG
  • Member for 10 years, 9 months
  • Last seen more than a week ago
3 answers
10 votes
5k views
2 bookmarks
Users complain that system runs slow when mysqldump is in progress
4 answers
25 votes
6k views
5 bookmarks
If NoSQL stands for "Not only SQL", is SQL a subset of NoSQL?
3 answers
7 votes
1k views
5 bookmarks
How to treat numbers within strings as numbers when sorting ("A3" sorts before "A10", not after)
3 answers
8 votes
17k views
4 bookmarks
Why is my MySQL dump file and my phpMyadmin export file different sizes?
3 answers
2 votes
74 views
1 bookmarks
How can I design a relational database with words that are all related to each other
4 answers
31 votes
16k views
11 bookmarks
Is it bad to have index space larger than data space?
2 answers
52 votes
11k views
23 bookmarks
Is it a bad practice to have several mutually exclusive one-to-one relationships?
3 answers
32 votes
23k views
7 bookmarks
Why is it recommended to store BLOBs in separate SQL Server tables?
2 answers
3 votes
17k views
2 bookmarks
What is the difference between NULL and \N while loading data from a csv using load data local infile
3 answers
6 votes
3k views
4 bookmarks
Why are there different levels of MySQL collation/charsets?
3 answers
8 votes
35k views
3 bookmarks
SQL Server Collation for Arabic, Hebrew, English and French
3 answers
25 votes
5k views
6 bookmarks
Which collation should I choose for a muiti-language website?
18 answers
102 votes
37k views
34 bookmarks
Is adding the ‘tbl’ prefix to table names really a problem?
2 answers
5 votes
7k views
3 bookmarks
Why not use SQL_Latin1_General_CI_AS for a global system?
2 answers
0 votes
2k views
1 bookmarks
Why are there different Database Collations for different languages?
1 answer
4 votes
924 views
4 bookmarks
Howto find out details and reasons for idle transactions?
7 answers
200 votes
266k views
119 bookmarks
How can I optimize a mysqldump of a large database?
2 answers
18 votes
4k views
3 bookmarks
Why does SQL Injection not happen on this query inside a stored procedure?
12 answers
24 votes
9k views
8 bookmarks
Why are constraints applied in the database rather than the code?
12 answers
150 votes
94k views
71 bookmarks
Should binary files be stored in the database?
7 answers
53 votes
172k views
17 bookmarks
In what data type should I store an email address in database?