Optimizing Database Structure: Separating Values into Separate Tables vs Inline Data Storage

How to Select Distinct IDs from One Table Based on Rules from Another Table

Passing Table-Valued Parameters with ExecuteStoreQuery: A Powerful Feature in SQL Server