• http://msdn.microsoft.com/en-US/library/ms189858(v=sql.105).aspx

    See link. It's an either by partition or all.

    *****

    Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P