Where's the link to the next level?

I felt the same disappointment as getting to the end of an hour-long episode of a serial TV show: "Aw man, gotta wait...

I think I'd have to congratulate whoever wrote that: ...

Not using DRI and instead relying on applications to ensure business rules feels to me like not wearing underwear: you might be able to get away with it most...

It depends on how frequently "sometimes requested" is, and how big a datatype that extra column is. Since an index is a tree structure, adding that extra column as...

I would like to have seen more comparison of the difference between included columns and additional columns in the index key.

I appreciate the distinction that they are stored as "extra"...

In addition to the phone number and zip code decomposition I'd like to mention another is-it-atomic data: email address. You can't really do much without the whole thing in...

1) Good job on the topic: it caught my attention. That alone is a considerable feat in a world of information overload.

2) Where's the rest of it?...

arty 15255 (2/24/2011)

---

I like newbies 🙂

You can always correct their sql statments 🙂

...

UPDATE tbl_kvp SET

@value = column_value+1,

column_value = @value

WHERE column_key = @key

...

(that avoids...

Hugo Kornelis (2/11/2011)

The reason the resource database was introduced was to make applying service packs easier. Instead of dropping and creating system objects in the master database, the SP executable...

Can you get the link to the forum into the daily/weekly emails?

I'd click it with some frequency but if it doesn't get any "eyes on" i won't think about it.

kenambrose (1/22/2011)

---

Well I guess you totally and completely missed my point. If there is a more fundamental and foundational concept to db design than preventing duplicates, I don't know...

part 2+ could discuss the ongoing success of Bob's business:

Returning customers update their address info, Alice is rightly concerned about the loss of information when Bob overwrites the old records...

I agree that processes should serve... In the case of low-skilled operators the process serves to constrain behaviors to those that are safe for system integrity. With higher-skilled operators...

well for ad-hoc examination it was much better to...

I don't have enough experience to comment on the techniques presented, but I wanted to congratulate you on a well-written article. Some authors expect the pictures should speak for...