Of course (and thank you for the link).

It's like the people comparing things via their hash code - has been on the books for decades ... but still.

Years later - if someone stumbles over this: WITH(NOLOCK) can get locks for non-SELECT statements, for example, it will get locks if it is part of an UPDATE statement. Especially,...

David - long after you wrote

Does anyone have comments or experiences to relate about the CQRS pattern and its implications for the database tier? I have got some views (and...

JJ B (11/26/2007)...Let's relate this discussion back to the article in question: Maybe instead of creating the database/tables as the first step after vaguely describing the project, Steve should have...

Matt Lacey (11/21/2007)

If anyone was unsure of what was required they have obviously forgotten the golden rule "If you are unsure, ask!"

The next most important rule, which also seems to...

G Bryant McClellan (11/20/2007)

WARNING...SOAPBOX APPROACHING...With regard to the image URL storage, why not simply record a URL or file path? Why bother with storing images in SQL Server? Granted SQL...

In this case, most probably not (see e.g. here, but there are...

A Design issue:

The indices seem totally ad-hoc. As a rule of thumb, clustered indices should be on the (logical or technical) primary key - i.e., on the isbn column for...

["you" means "anyone" in my posting; "Steve" is "Steve" :-)]

... let me ramble on a bit more about basic issues of requirements and design (if you only want to read...

Sorry if I come in "high-level", but what irritates me most is that there is no high-level description of what is needed. Some of the previous posters' remarks show this:...

A somewhat off-topic remark: You write "As we're publishing more now there are 13 digit ISBNs ...". Just as background information ... reality is somewhat complicated here: Actually, the first...