Wednesday, September 26, 2007

Getting row with latest timestamp

Idea of having a separate table with current status

http://www.sql-server-performance.com/articles/per/history_status_table_performance_p2.aspx

What if, since they should be inserted in order of time, we just did a MAX(id)?

No comments: