Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall'
  • Member for 13 years, 2 months
  • Last seen this week
  • United States
1 vote
Accepted

How do I filter a set of child records to get a single child record for each parent?

2 votes

In Azure, what's the best setup for creating a development db with a production db? Replication, mirroring, copying, copy then sync, etc?

2 votes

How to estimate database size needed?

2 votes

Normalizing an old database

158 votes

List all columns for a specified table

2 votes

generate a series of dates in progress-db

2 votes

Best way to double check query results are right on large tables

0 votes

Creating tables and triggers dinamically

4 votes

Understanding about SQL index on DateTime Column

9 votes

Sort order specified in primary key, yet sorting is executed on SELECT

1 vote

SQL: How can you release or prevent update/insert locks while remaining in the transaction?

49 votes

Good explanation of cascade (ON DELETE/UPDATE) behavior

1 vote

Postgresql. Real-time copy of a database to another disk on the same server

3 votes

Is it possible to export postgres database without views?

7 votes
Accepted

Select column from ALL tables

4 votes

Is there a way to avoid duplicating the definition of a foreign key?

21 votes
Accepted

Arbitrarily ordering records in a table

17 votes
Accepted

Foreign keys - link using surrogate or natural key?

2 votes

PostgreSQL: Query for location of global tablespace?

1 vote
Accepted

PRIMARY index not used if too few entries

79 votes
Accepted

How to get a working and complete PostgreSQL DB backup and test

5 votes

Postgres Server access restricted to only one database from list of databases

3 votes

COUNT(*) on InnoDB whenever phpMyAdmin loads

2 votes

updating millions of rows in multiple tables sql server 2005

3 votes

Source control makes sure my code is never lost, how do I make sure my users/orders database is never lost?

4 votes

Simple table normalisation

5 votes

Is there any rule of thumb to optimize sql queries like this

3 votes

How to get the total days per month between two dates?

2 votes
Accepted

What is a standard or conventional name for a column representing display order?

2 votes
Accepted

Plan for managing financial transactions in an easily and retrievable manner, indefinitely

1
2 3 4 5 6