Database Administrators Stack Exchange by Kiwix

Q&A for database professionals who wish to improve their database skills and learn from others in the community

Most popular questions

935 How do I list all databases and tables using psql? 2011-02-17T08:45:49.610

404 What's the difference between a temp table and table variable in SQL Server? 2012-04-11T22:22:32.080

318 How do you mysqldump specific table(s)? 2011-12-16T20:39:37.727

255 Can MySQL reasonably perform queries on billions of rows? 2012-07-02T19:36:13.747

207 Why Does the Transaction Log Keep Growing or Run Out of Space? 2012-12-05T02:11:22.107

202 How do you document your databases? 2011-01-11T07:39:29.910

180 What are the main differences between InnoDB and MyISAM? 2011-01-03T20:46:02.927

173 How can I time SQL-queries using psql? 2011-06-03T10:22:54.540

158 How do I list all columns for a specified table 2012-08-13T12:44:44.887

150 What's the difference between a CTE and a Temp Table? 2012-02-15T16:47:27.183

148 How do I list all schemas in PostgreSQL? 2013-04-15T19:19:16.907

145 When should I use a unique constraint instead of a unique index? 2011-01-04T10:32:27.827

145 How can I monitor the progress of an import of a large .sql file? 2012-05-02T16:54:41.177

141 How can I optimize a mysqldump of a large database? 2011-01-03T21:13:48.603

141 Should developers be able to query production databases? 2012-01-06T15:57:00.620

125 When should a primary key be declared non-clustered? 2011-11-10T21:31:59.400

123 How large should be mysql innodb_buffer_pool_size? 2012-10-21T15:03:45.757

107 How can I move a database from one server to another? 2011-01-04T15:38:47.870

104 How to insert values into a table from a select query in PostgreSQL? 2011-05-27T08:33:05.377

100 Granting access to all tables for a user 2013-02-01T03:27:09.290

99 connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host 2014-12-01T10:54:58.410

97 Files - in the database or not? 2011-04-29T12:02:51.200

96 Why shouldn't we allow NULLs? 2011-08-30T21:11:39.087

96 Why are numbers tables "invaluable"? 2012-01-25T00:45:27.447

94 How to determine if an Index is required or necessary 2011-01-03T22:59:58.937

92 Why is Database Administration so hard? 2011-05-24T13:33:39.683

91 Where are some useful SQL puzzles to teach SQL in a workplace? 2011-01-03T21:26:35.980

91 Possible to make MySQL use more than one core? 2011-09-12T14:59:54.003

90 Why use both TRUNCATE and DROP? 2011-07-27T17:36:39.317

89 Granting a user account permission to create databases in PostgreSQL 2013-01-21T20:28:24.833

88 How to safely change MySQL innodb variable 'innodb_log_file_size'? 2011-02-16T15:01:01.553

85 How do I find PostgreSQL's data directory? 2011-02-20T12:10:34.060

84 Advantages and Disadvantages to using ENUM vs Integer types? 2011-10-19T15:50:08.357

79 When to use TINYINT over INT? 2011-08-23T14:25:24.507

79 Is adding the ‘tbl’ prefix to table names really a problem? 2016-11-04T12:13:14.337

78 Why can't RDBM's cluster the way NoSQL does? 2013-02-17T16:19:52.793

76 Do stored procedures prevent SQL injection? 2011-01-04T07:24:30.653

76 Does SQL Server read all of a COALESCE function even if the first argument is not NULL? 2011-09-19T15:06:59.757

75 Storing vs calculating aggregate values 2011-01-05T01:32:11.040

73 Are SQL Server in-place upgrades as ill advised as they used to be? 2012-11-27T01:10:45.920

72 How to get the current date without the time part 2011-02-24T14:32:56.293

72 SQL: SELECT All columns except some 2011-03-29T08:19:55.863

71 PostgreSQL multi-column unique constraint and NULL values 2011-12-27T09:10:21.130

71 Retrieving n rows per group 2014-12-17T14:33:48.817

70 When to use NULL and when to use an empty string? 2011-01-03T23:05:38.630

70 ALTER TABLE - Rename a column 2014-03-29T09:53:24.090

69 Guid vs INT - Which is better as a primary key? 2011-01-05T07:46:34.807

69 List the database privileges using psql 2011-08-03T19:01:21.210

68 Good explanation of cascade (ON DELETE/UPDATE) behavior 2013-06-20T14:18:32.647

67 What are the differences between NoSQL and a traditional RDBMS? 2011-01-03T20:52:52.880

Tags

  All tags