And the EAV winner is …. sparse columns
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
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
ORDPATH is a hierarchical labeling scheme used in the internal implementation of the XML data type in SQL Server 2005. It's meant to provide optimized
SQL Server 2008 will contain, if my count is correct, 7 new data types. Note: none of these are in the current CTP. DATE – ANSI-compliant
Had to write about another thing that "caught my ear" at TechEd during a chalktalk by Rick Negrin about Service Broker usage patterns. Service Broker
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.