Reputation
7,360
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 11 24
Newest
 Yearling
Impact
~186k people reached

Sep
26
answered Configuration Table
Sep
20
comment designing multiple tables while eliminating duplication?
@axrwkr - I use Visio with James Martin ERD smart shapes that I built myself and a custom line pattern to give it the hand-drawn look for rough sketches. I find that if a diagram looks too formal some people won't treat it as a rough model, no matter how much you try to convince them otherwise!
Sep
18
comment Optionally free-form reference
Your second approach is a very formal sub-typing schema. It is what you should have in a logical model. Your first approach is a fairly sensible compromise for simplicity and is what you'd likely have in a physical model.
Sep
17
awarded  Nice Answer
Sep
10
answered Normalizing nearly identical tables
Sep
8
answered Which schema is better for a shopping project?
Sep
5
comment Design concerns for using 3x bit or one char(1) or one integer in table for holding status of item
@adopilot - Depending on how selective your bit columns are, full table indexes on bit columns can be helpful. In other words, if only a small minority of your rows have a bit flag with a given value (0 or 1) and you are always looking for that more rare value, then a full table index will be helpful. In other conditions, you can use filtered indexes as correctly suggested by Aaron Bertrand.
Sep
5
answered Design concerns for using 3x bit or one char(1) or one integer in table for holding status of item
Aug
30
revised When to stop splitting tables?
expanded consideration of business rules
Aug
30
answered How do I deal with items that I need to repeat monthly?
Aug
30
answered When to stop splitting tables?
Aug
30
revised Is database normalization dead?
Grammar!
Aug
30
revised Removing “duplicates” within a time range
Added the solution for in and out
Aug
29
comment Removing “duplicates” within a time range
@RLF - Agreed, there are a lot of other possible complications, but OP's question didn't specify any of those. Including lanes is necessary if there is more than one camera reading plates. Similarly, if you want to avoid missing "in and out" situations, you might have to capture when cars leave or make an assumption, as you suggest, about how long a gap should force the presumption of a new visit.
Aug
29
revised Removing “duplicates” within a time range
Another SQL Fiddle tweak
Aug
29
answered Removing “duplicates” within a time range
Aug
28
awarded  Yearling
Aug
17
answered Whether or not to create separate tables
Aug
12
comment Handling or preventing conflicts in a multi-user system
+1 for optimistic concurrency. Note that if you happen to be using SQL Server, there is a native data type called rowversion which automatically assigns a new value each time the record is written to. This same data type was previously known as timestamp, but that syntax is deprecated.
Aug
9
revised How to link a customer to a country when the city/state isn't known
Clarified language.