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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

185 Create a MySQL database with charset UTF-8 2014-09-17T03:13:43.087

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

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

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

167 Help installing SQL Server 2017 - VS Shell installation has failed with exit code 1638 2017-11-03T23:29:34.693

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

162 Force drop db while others may be connected 2012-01-30T11:28:09.503

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

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

142 Should binary files be stored in the database? 2011-04-29T12:02:51.200

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

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

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

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

130 How do I move SQL Server database files? 2013-10-22T12:26:26.570

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

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

124 How to get the name of the current database from within PostgreSQL? 2014-02-05T21:16:56.757

123 Optimizing queries on a range of timestamps (two columns) 2013-04-09T19:07:03.027

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

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

117 Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL 2012-01-15T11:24:02.327

115 Is it safe to delete mysql-bin files? 2013-04-26T20:56:52.687

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

112 How do I get the current unix timestamp from PostgreSQL? 2011-05-18T08:27:10.853

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

110 Measure the size of a PostgreSQL table row 2012-09-07T09:39:22.020

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

109 SQL Server Management Studio 18 won't open (only splash screen pops up) 2019-04-30T23:49:00.127

108 How to properly format sqlite shell output? 2013-04-23T05:24:46.893

106 mysql: Show GRANTs for all users 2012-08-28T10:28:32.173

106 Is it a bad practice to always create a transaction? 2013-05-28T15:43:27.643


  All tags