Post reply

QOD 12/31

  • December 31, 2003 at 9:15 am

    #160325

    Since SQL 2000 databases have a limit of 1,048,516 TB, doesn’t that mean that a table cannot exceed that limit?

  • December 31, 2003 at 2:47 pm

    #488409

    quote:

    Since SQL 2000 databases have a limit of 1,048,516 TB, doesn’t that mean that a table cannot exceed that limit?

    Yes! I thought the same thing, but since it wasn't an available choice, you have to go with the correct choice that is given (which I won't include here to spoil the question for people who might be trolling for answers!). That size is the (theoretical) limit on *data* files, and since you have to allow for GAMs, SGAMs, etc., and only 8060 bytes on a page ... argh, you do the math. The tables can be BIG. 8D

  • December 31, 2003 at 4:29 pm

    #488418

    I was thrown by the same thing. None of the answers looked correct to me.

  • January 4, 2004 at 6:07 pm

    #488600

    I'm thinking the same thing.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply