Skip to main content
Quassnoi's user avatar
Quassnoi's user avatar
Quassnoi's user avatar
Quassnoi
  • Member for 13 years, 5 months
  • Last seen this week
8 votes

Is there a performance penalty for unique key constraint violations in Postgres?

5 votes

Is it bad practice to have a "most_recent" boolean column in addition to a "create_at" timestamp column to track the latest version of a record?

5 votes
Accepted

How can I speed up a query that orders by a calculated field?

5 votes

Fetch a row that contains the set of last non-NULL values for each column

4 votes
Accepted

Why changing the database owner doesn't change the owner in PostgreSQL dump?

3 votes

Write Query to get 'x' number of rows in SQL Server

3 votes

Conditional selection in a GROUP BY clause

3 votes

How to get the data of a recent year

2 votes
Accepted

SUM and Group By Optimization

2 votes
Accepted

inner join on PK with extra criteria slow despite indices?

2 votes

Most performant SQL query needed

2 votes

How can I get an average from a query dataset in SQL Server?

2 votes

Is my queue table implementation race condition safe?

1 vote

Why PostreSQL 9.2 does not use index scan if it can?

0 votes

Query 2 tables without a join