Highest Voted Questions - Database Administrators Stack Exchange

174

votes

13 answers

Should binary files be stored in the database?

What is the best place for storing binary files that are related to data in your database? Should you: Store in the database with a blob Store on the filesystem with a link in the database Store in the filesystem but rename to a hash of the…

database-design blob

asked Apr 29 '11 at 12:02

Jack Douglas

40,517
16
106
178

174

votes

5 answers

How to list all constraints of a table in PostgreSQL?

How to list all constraints (Primary key, check, unique mutual exclusive, ..) of a table in PostgreSQL?

postgresql

asked Aug 14 '18 at 07:32

Thirumal

2,548
3
16
24

172

votes

4 answers

Help installing SQL Server 2017 - VS Shell installation has failed with exit code 1638

Any suggestions on how to deal with this error: TITLE: Microsoft SQL Server 2017 Setup ------------------------------ The following error has occurred: VS Shell installation has failed with exit code 1638. For help, click:…

sql-server installation sql-server-2017

asked Nov 03 '17 at 23:29

Jonathan Allen

3,612
7
25
25

169

votes

13 answers

How can I move a database from one server to another?

How can I move MySQL tables from one physical server to another? Such as this exact scenario: I have a MySQL server that uses innodb table and is about 20GB size. I want to move it to a new server, what's the most efficient way to do this?

mysql backup migration mysqldump

asked Jan 04 '11 at 15:38

John

1,851
2
14
10

162

votes

9 answers

How to properly format sqlite shell output?

If I go to mysql shell and type SELECT * FROM users I get - +--------+----------------+---------------------------------+----------+-----------+--------------------+--------------------+ | USERID | NAME | EMAILID |…

sqlite

asked Apr 23 '13 at 05:24

Kshitiz Sharma

3,357
9
33
35

161

votes

3 answers

PostgreSQL multi-column unique constraint and NULL values

I have a table like the following: create table my_table ( id int8 not null, id_A int8 not null, id_B int8 not null, id_C int8 null, constraint pk_my_table primary key (id), constraint u_constrainte unique (id_A, id_B,…

postgresql constraint null unique-constraint

asked Dec 27 '11 at 09:10

Manuel Leduc

1,721
2
11
5

160

votes

12 answers

How do I move SQL Server database files?

I have a database and want to move the .mdf and .ldf files to another location. But I do not want to stop the MSSQLSERVER service, and I do not want to export to another server. How can I do this?

sql-server sql-server-2012 backup

asked Oct 22 '13 at 12:26

user2645263

152

votes

4 answers

Is it safe to delete mysql-bin files?

I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those files like mysql-bin.000123, mysql-bin.000223 etc.…

mysql replication mariadb mysql-5 binlog

asked Apr 26 '13 at 20:56

user18530

152

votes

3 answers

How can I specify the position for a new column in PostgreSQL?

If I have a table with the columns: id | name | created_date and would like to add a column, I use: alter table my_table add column email varchar(255) Then the column is added after the created_date column. Is there any way I can specify the…

postgresql database-design

asked Jun 12 '11 at 13:36

Jonas

33,945
27
62
64

151

votes

3 answers

Advantages and Disadvantages to using ENUM vs Integer types?

Lets say in some random table, you have a column named status. It's real-world values would be either enabled or disabled. Is it better for this column's data type to be an int/bool (1 or zero) or to use ENUM with the values being enabled and…

mysql database-design datatypes

asked Oct 19 '11 at 15:50

Jake Wilson

2,487
8
22
23

151

votes

1 answer

Postgres UPDATE ... LIMIT 1

I have a Postgres database which contains details on clusters of servers, such as server status ('active', 'standby' etc). Active servers at any time may need to fail over to a standby, and I don't care which standby is used in particular. I want a…

postgresql update concurrency queue

asked Jul 01 '14 at 16:54

vastlysuperiorman

1,685
2
11
8

149

votes

8 answers

Pattern matching with LIKE, SIMILAR TO or regular expressions

I had to write a simple query where I go looking for people's name that start with a B or a D: SELECT s.name FROM spelers s WHERE s.name LIKE 'B%' OR s.name LIKE 'D%' ORDER BY 1 I was wondering if there is a way to rewrite this to become more…

postgresql index pattern-matching regular-expression string-searching

asked Jan 15 '12 at 11:24

Lucas Kauffman

1,835
4
17
18

148

votes

4 answers

Optimizing queries on a range of timestamps (two columns)

I use PostgreSQL 9.1 on Ubuntu 12.04. I need to select records inside a range of time: my table time_limits has two timestamp fields and one integer property. There are additional columns in my actual table that are not involved with this…

postgresql index optimization postgresql-9.1 explain

asked Apr 09 '13 at 19:07

Stephane Rolland

8,911
11
33
40

147

votes

11 answers

How to easily convert utf8 tables to utf8mb4 in MySQL 5.5

I have a database which now needs to support 4 byte characters (Chinese). Luckily I already have MySQL 5.5 in production. So I would just like to make all collations which are utf8_bin to utf8mb4_bin. I believe there is no performance loss/gain with…

mysql

asked Nov 22 '11 at 12:18

geoaxis

1,807
2
13
11

146

votes

8 answers

How to turn JSON array into Postgres array?

I have a column data of type json that holds JSON documents like this: { "name": "foo", "tags": ["foo", "bar"] } I would like to turn the nested tags array into a concatenated string ('foo, bar'). That would be easily possible with the…

postgresql postgresql-9.3 array json

asked Dec 02 '13 at 20:48

Christoph

1,653
2
12
8

Most Popular