Eric M Russell (9/2/2015)
We all just need to come to terms with the fact that application programmers have a need to locally persist things like shopping carts, messaging, or just generic objects. It doesn't fit well within a relational model, or it just doesn't need a relational model, and that's OK, because what they're doing is not real database design in the first place.
Agreed. Let's keep the unstructured data out of structured storage and treat structured storage as if it had, you know, a structure.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning