Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server - Waterfox. Published: February 17, 2005 Authors: Gandhi Swaminathan Contributors: Hao Chen, Rakesh Gujjula, Gang He Reviewers: Wey Guy, Stuart Ozer, Arun Marathe, John Miller, Mike Ruthruff, Brian Goldstein Published: January 2005.
Using Partitions in a Microsoft SQL Server 2000 Data Warehouse - Waterfox. Author: Joy Mundy Contributors: Stuart Ozer, Lubor Kollar, Len Wyatt Microsoft Corporation February 2001 Summary: This article describes how to use partitions to improve the manageability, query performance, and load speed of data warehouses in SQL Server 2000 Enterprise Edition.
SQL Databases Don't Scale. How to share data between stored procedures. An SQL text by Erland Sommarskog, SQL Server MVP.
Most recent update 2013-11-02. Introduction This article tackles two related questions: How can I use the result set from one stored procedure in another, also expressed as How can I use the result set from a stored procedure in a SELECT statement? How can I pass a table data in a parameter from one stored procedure to another? A Gentle Introduction to SQL.