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, 3 months
  • Last seen this week
  • United States
2 votes
Accepted

Which of tables key to reference?

2 votes

Object-oriented programming CRUD design pattern

2 votes
Accepted

Design database to query a date range for scheduling

2 votes

Writing to a DKNF database, but reading from a de-normalized table for performance?

2 votes

Broken SELECT in Sql Server Compact 3.5 SP2?

2 votes

3NF decomposition + database normalization

2 votes
Accepted

Does this design satisfy 3NF, and can any improvements be made?

2 votes

Importance of ER Diagrams

2 votes

How to create unique index for month and year column?

2 votes

Data type for a fuzzy date?

2 votes

Database Design Regarding a Relationship for Patient Visit

2 votes
Accepted

How to Reorganize Microsoft Access Table

2 votes

PostgreSQL Database Migration

2 votes

How to estimate database size needed?

2 votes

~15 data sets w/ 25k rows & ~20 columns + quick one time reports = Access VS SQL?

2 votes
Accepted

database normalization and optimization for postOffice DB

2 votes

PostgreSQL: Query for location of global tablespace?

2 votes

Optimizing InnoDB default settings

2 votes

How do I rule out SQL Server as the reason for a slow website

2 votes

Tools to migrate from SQLite to PostgreSQL

2 votes

Database Design for Airline Reservation System

2 votes

Design of fact table(s) and dimensions tables for data warehouse

2 votes

generate a series of dates in progress-db

2 votes

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

2 votes

Normalizing an old database

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?

1 vote
Accepted

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

1 vote

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

1 vote

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

1 vote

Optimizing query using view on EAV structure