All,

> > I think Nickolay mentioned around 13 Gb but my memory could be
> > faulty regarding the actual number.
>
> The size limit is more in the 40-80GB per table range, although I'm

not

> sure if this would change when blobs are used.
>
> In fact, I'm not sure I agree with Nickolay's math, I will discuss

with

> him and get back to you (all).

Ok, here goes.

Unfortunately, the practical/usable value is determined by a number of
factors, which makes it difficult to predict the operational limit. The
factors include:

- Size of record,

- "compressability" of the row data

- Presence of "in-page" blobs (blobs which can fit on the same db page
as the related data record).


The absolute size limit of a table is 80GB of on disk storage,
regardless of page size, not including off-page blobs which are stored
on disk pages outside of the table data.


Sean