Post reply

TempDB Database

  • December 9, 2014 at 6:01 am

    #295814

    how to know the limitation of number of objects(Maximum no.of objects allow tempdb database) in a tempdb database?

  • December 9, 2014 at 6:45 am

    #1763501

    you will most likely run out of disk space long before you approach the max number of objects.

    this is the max for any database, regardless of being a user db, tempdb, or whatever.

    because object_id is an int, the most you can have is select power(2,31) -1

    objects or basically 2 billion objects.(2,147,483,647)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 9, 2014 at 7:27 am

    #1763520

    Lowell (12/9/2014)

    you will most likely run out of disk space long before you approach the max number of objects.

    this is the max for any database, regardless of being a user db, tempdb, or whatever.

    because object_id is an int, the most you can have is select power(2,31) -1

    objects or basically 2 billion objects.(2,147,483,647)

    That sure would make tempdb big, wouldn't it? I don't have that kind of disk space. You might have to bounce the service some time before you get there.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

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

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