As of May 31, 2023, we have updated our Code of Conduct.
Database Administrators

Favorite Question

 Favorite Question
Question saved by 25 users. This badge can be awarded multiple times.
Awarded 158 times.
Why are numbers tables "invaluable"?
Awarded Nov 19, 2015 at 11:16
Advantages and Disadvantages to using ENUM vs Integer types?
Awarded Nov 16, 2015 at 18:21
Working of indexes in PostgreSQL
Awarded Aug 30, 2015 at 8:05
How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora
Awarded Aug 18, 2015 at 7:08
What event information can I get by default from SQL Server?
Awarded Aug 7, 2015 at 20:34
Do stored procedures prevent SQL injection?
Awarded Jun 30, 2015 at 4:10
Which database could handle storage of billions/trillions of records?
Awarded Jun 24, 2015 at 11:48
Writing a simple bank schema: How should I keep my balances in sync with their transaction history?
Awarded Jun 18, 2015 at 17:08
How can I monitor the progress of an import of a large .sql file?
Awarded May 19, 2015 at 9:49
Should developers be able to query production databases?
Awarded May 15, 2015 at 16:59
Why shouldn't we allow NULLs?
Awarded May 11, 2015 at 12:46
Why use both TRUNCATE and DROP?
Awarded Apr 29, 2015 at 2:09
What is the best way to reduce the size of ibdata in mysql?
Awarded Apr 16, 2015 at 13:15
Should binary files be stored in the database?
Awarded Apr 7, 2015 at 17:22
Find highest level of a hierarchical field: with vs without CTEs
Awarded Feb 9, 2015 at 3:25
What's the difference between a CTE and a Temp Table?
Awarded Jan 22, 2015 at 8:36
About single threaded versus multithreaded databases performance
Awarded Jan 5, 2015 at 8:43
Commonly Used Acronyms by Database Administrators
Awarded Nov 19, 2014 at 17:32
Is there a name for this database schema of key values?
Awarded Nov 19, 2014 at 17:32
Which is faster, InnoDB or MyISAM?
Awarded Nov 4, 2014 at 9:09
How do you mysqldump specific table(s)?
Awarded Sep 17, 2014 at 10:18
How to safely change MySQL innodb variable 'innodb_log_file_size'?
Awarded Jul 3, 2014 at 13:40
How large should be mysql innodb_buffer_pool_size?
Awarded Jun 5, 2014 at 14:49
How to determine if an Index is required or necessary
Awarded Apr 24, 2014 at 4:20
Why is Database Administration so hard?
Awarded Mar 7, 2014 at 17:45
Why Does the Transaction Log Keep Growing or Run Out of Space?
Awarded Jan 26, 2014 at 18:24
Possible to make MySQL use more than one core?
Awarded Nov 14, 2013 at 22:17
What are the differences between NoSQL and a traditional RDBMS?
Awarded Oct 23, 2013 at 19:12
How can I move a database from one server to another?
Awarded Oct 13, 2013 at 17:27
Why can't RDBM's cluster the way NoSQL does?
Awarded Sep 20, 2013 at 10:10
How do I list all databases and tables using psql?
Awarded Jun 4, 2013 at 14:43
How can I optimize a mysqldump of a large database?
Awarded Feb 18, 2013 at 22:28
How can a group track database schema changes?
Awarded Jan 29, 2013 at 21:15
Can MySQL reasonably perform queries on billions of rows?
Awarded Jul 19, 2012 at 21:04
What are the main differences between InnoDB and MyISAM?
Awarded May 16, 2012 at 7:39
What's the difference between a temp table and table variable in SQL Server?
Awarded May 9, 2012 at 4:55
How do you document your databases?
Awarded Mar 8, 2012 at 8:14
Where are some useful SQL puzzles to teach SQL in a workplace?
Awarded Mar 6, 2012 at 2:00
1 2
3

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.