bbaird's user avatar
bbaird's user avatar
bbaird's user avatar
bbaird
  • Member for 2 years, 2 months
  • Last seen more than a month ago
  • United States
33 votes
Accepted

Why is this MySQL query taking so long?

8 votes
Accepted

Save performance with large update on Index with Included Column

7 votes
Accepted

Generate all combinations of a list of strings

6 votes
Accepted

Should I use null or a separate table?

5 votes

Why Cassandra is not considered a relational database?

5 votes
Accepted

Is a Non-Clustered index needed when referencing a small table with a Foreign Key

5 votes
Accepted

Is it a good approach to design tables according to the queries I'll perform on it?

4 votes

Stored Procedure with two options that execute different actions depending on their values

4 votes

MySQL - Can I have quick queries in a table with 200 million rows?

4 votes
Accepted

Need to add leading zeroes to string representing a date

4 votes

Count number of occurences per location per hour in PostgreSQL

4 votes
Accepted

Query slow when a sub select is used

4 votes
Accepted

Which database to use when you have a 6 billion of rows inside and need to query rows with from list of IDs?

3 votes

Incorrect relationships formed in EER diagram by reverse engineering the database script

3 votes
Accepted

How do I efficiently query for records that share a year?

3 votes
Accepted

How can I filter on result of aggregate functions like min, max, sum?

3 votes
Accepted

Postgres foreign key to a foreign key

3 votes

SQL query 2 tables using String without intersect

3 votes

Get the row ID of the record which has the Max Date

3 votes

Best Practice to define has many through relationship

3 votes
Accepted

Entity-relationship for database design

3 votes

DB2 replace emoji in text string

3 votes
Accepted

Non-product invoice items

2 votes

SQL Server Index Drops - Considerations

2 votes
Accepted

MSQL - Switching rows to columns

2 votes

Storing Live Timeseries Data in SQL Server Azure Database

2 votes
Accepted

Time-series window query for calculating rolling average across group by subquery is inaccurate due to missing rows

2 votes

Multiple FK poiting to single column

2 votes

How to extract variation values with MYSQL query

2 votes

Multiple group by with inner query in Oracle

1
2 3 4 5