Blog Post

How Many Objects Can Own Pages in a Mixed Extent

,

I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for a temp table. The replier (blog|@sqL_handLe) — whom you should be following if you’re not already, very smart guy — gave the classic response about mixed extents and how they can be owned by up to 8 objects. The link he provided, Understanding Pages and Extents, agrees with him and says, “Mixed extents are shared by up to eight objects”.

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating