Database Administrators
Sponsored by
Sponsored logo
user avatar
user avatar
user avatar
TRiG
  • Member for 10 years, 9 months
  • Last seen more than a week ago
Profile Activity

21 Bookmarks

Score Activity Newest Views Added
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?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.