Mike Sherrill 'Cat Recall'

less info
5,177 reputation
823
bio website
location United States
age
visits member for 3 years, 1 month
seen 21 hours ago

Database design and software development consultant. My clients included everything from Fortune 100 companies to non-profits and mom-and-pop companies. I've worked with SQL databases since 1985. I'm a database generalist; I'm comfortable with every modern SQL dbms. My home server runs a half-dozen different database management systems. I test most of my answers under more than one of them.

I've also developed relational models for implementation in non-SQL environments, like Lotus Notes and plain C++ code.

I'm known for frequently saying

  • ID numbers have nothing to do with normalization.
  • Everything you know about state codes is wrong.
  • Table names, column names, etc., are your database's API.
  • Natural keys reduce the number of joins, and often improve performance.
  • 5NF is your friend.
  • Don't assume. Test.

Feb
3
answered Source control makes sure my code is never lost, how do I make sure my users/orders database is never lost?
Sep
28
answered Simple table normalisation
Sep
9
answered Is there any rule of thumb to optimize sql queries like this
Sep
4
answered How to get the total days per month between two dates?
Jul
31
answered What is a standard or conventional name for a column representing display order?
Jul
23
answered Plan for storing transactions in an easily retrievable manner, indefinitely
Jul
22
answered Constraint on Composite Type
Jul
14
answered optimizing MySQL for traffic analytics system
Jul
10
answered How to estimate/predict data size and index size of a table in MySQL
Jul
9
answered Indexes and Optimizations for Logging System
Jun
29
answered what is the best practice when making changes to the the application and database?
Jun
27
answered MySQL system date change impact
Jun
27
answered How to calculate total ON hours and Total OFF hours in day of a motor using PHP and MySQL
Jun
20
answered Good explanation of cascade (ON DELETE/UPDATE) behavior
Jun
19
answered Is it ok to let users add new columns and tables to your database?
Jun
16
answered Is it possible to avoid filesort?
May
21
answered Dropping Hypothetical Indexes
Apr
25
answered Enforce indirect relationship
Apr
25
answered Which of tables key to reference?
Apr
25
answered What is the benefit of two FK, when one of them can be deduced from another table?