One of the uses for sparse columns will likely be replacing entity-attribute-value designs. In an EAV design, the "sparse attribute" values are represented by a
I'm still getting used to the new sparse column feature in SQL Server 2008. I'd just read in the BOL definition of ALTER TABLE that
I've been talking with folks for (it seems like) a long time about modeling sparse attributes in a relational database. Seems like I run into
Many of you have already heard the "hardware store" story. What's the best way to model products in a hardware store, where new items arrive
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.