User efesar

9 votes

Accepted

How do I determine if a column is defined as a serial data type instead of an integer based off the catalog?

answered Jul 26, 2013 at 21:33

7 votes

Accepted

could not save history to file "/var/lib/postgresql/.psql_history": No such file or directory

answered Jun 20, 2014 at 19:53

6 votes

How can I speed up a Postgres query containing lots of Joins with an ILIKE condition

answered Apr 2, 2014 at 19:50

6 votes

Accepted

select and count based on a condition

answered Apr 3, 2014 at 14:44

6 votes

What are the valid formats of a PostgreSQL schema name?

answered Jul 2, 2013 at 16:40

6 votes

Accepted

SQL Server 2012 Managment Studio not saving auto recovery files

answered Jan 23, 2014 at 23:02

5 votes

How to make SSMS upper case keywords

answered Aug 22, 2013 at 16:29

4 votes

PGAdmin3 connection with non standard SSH port and SSH tunnel

answered Mar 18, 2014 at 16:02

4 votes

Monitoring sql server

answered Apr 4, 2014 at 15:19

2 votes

Accepted

Why does SQlite return incorrect sum?

answered Apr 3, 2014 at 19:16

2 votes

Problem translating MySQL to PostgreSQL

answered Apr 3, 2014 at 21:58

2 votes

SQL Server: Additional cpus slow down batch

answered Sep 13, 2013 at 21:48

2 votes

Where to store versioned/historized records?

answered Jul 1, 2013 at 18:38

1 vote

Returning a True or False from an IIF statement

answered Jul 2, 2013 at 16:28

1 vote

SQL Server 2008 R2 Ent trial expired move to express?

answered May 23, 2013 at 21:41

1 vote

Accepted

Get old database off external hard drive

answered Jul 2, 2013 at 16:47

1 vote

Help with Postgres 9.1 data import (is 4x expected data size, 4x slower than MySQL, and index still needed)

answered Aug 13, 2013 at 20:33

1 vote

Accepted

migration sql 2003 to 2008, Sql side and php side

answered Aug 30, 2013 at 15:27

1 vote

Accepted

How do I solidify my SQL Server / T-SQL Knowledge?

answered Apr 8, 2014 at 19:37

0 votes

How to create a blank version of a PostgreSQL database

answered Nov 21, 2013 at 22:55

0 votes

Only do log backup if necessary in SQL Server

answered Apr 2, 2014 at 19:11

0 votes

Managing SQL Server 2008 R2 transaction logs when using principal/mirror databases

answered Mar 7, 2014 at 20:21

0 votes

Drop database owned by specific user in PostgreSQL

answered Mar 14, 2014 at 15:54

0 votes

Accepted

Show clients with staff assigned and no staff assigned

answered Aug 20, 2013 at 18:00

0 votes

TOAST Table Growth Out of Control - FULLVAC Does Nothing

answered Jul 3, 2013 at 20:14

0 votes

Best high availability solution to avoid maintenance downtime?

answered Jun 6, 2013 at 19:09

-2 votes

Query planner thinks doing a sequential scan on a very large table is faster than using an index?

answered Dec 12, 2013 at 16:22

Stack Exchange Network

27 Answers

How do I determine if a column is defined as a serial data type instead of an integer based off the catalog?

could not save history to file "/var/lib/postgresql/.psql_history": No such file or directory

How can I speed up a Postgres query containing lots of Joins with an ILIKE condition

select and count based on a condition

What are the valid formats of a PostgreSQL schema name?

SQL Server 2012 Managment Studio not saving auto recovery files

How to make SSMS upper case keywords

PGAdmin3 connection with non standard SSH port and SSH tunnel

Monitoring sql server

Why does SQlite return incorrect sum?

Problem translating MySQL to PostgreSQL

SQL Server: Additional cpus slow down batch

Where to store versioned/historized records?

Returning a True or False from an IIF statement

SQL Server 2008 R2 Ent trial expired move to express?

Get old database off external hard drive

Help with Postgres 9.1 data import (is 4x expected data size, 4x slower than MySQL, and index still needed)

migration sql 2003 to 2008, Sql side and php side

How do I solidify my SQL Server / T-SQL Knowledge?

How to create a blank version of a PostgreSQL database

Only do log backup if necessary in SQL Server

Managing SQL Server 2008 R2 transaction logs when using principal/mirror databases

Drop database owned by specific user in PostgreSQL

Show clients with staff assigned and no staff assigned

TOAST Table Growth Out of Control - FULLVAC Does Nothing

Best high availability solution to avoid maintenance downtime?

Query planner thinks doing a sequential scan on a very large table is faster than using an index?