Post reply

User Table size and limitations

  • January 22, 2010 at 10:22 am

    #144545

    Hi,

    How do I tell if there's a limit on how many users I can add to a user table? Is it possible to add as many users as necessary to a table? Just inquiring.

    Thanks.

  • January 22, 2010 at 11:19 am

    #1107475

    Look in Books On Line

    SQL Server 2005 Books Online (September 2007)

    CREATE TABLE (Transact-SQL)

    SQL Server 2005 can have up to two billion tables per database and 1,024 columns per table. The number of rows and total size of the table are limited only by the available storage

    Does this answer your question?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • January 22, 2010 at 12:56 pm

    #1107527

    How do I find out how many rows I have left in a user table? For example, right now, I have 300 users, I just need to know how many more users I can add before it the table maxes out. Sorry, im still a noob. Thnx

  • January 22, 2010 at 12:58 pm

    #1107530

    Until you run out of disk space. SQL Server does not restrict the number of rows that may exist in a table.

  • January 22, 2010 at 1:02 pm

    #1107533

    thanks guys!

  • January 22, 2010 at 1:11 pm

    #1107541

    The maximum size of a SQL database is 524 272 TB. Somehow I don't think, with 300 rows, you need to worry about hitting that limit any time soon.

    For what it's worth, the largest table that I've heard of someone having had in it 150 billion rows.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 22, 2010 at 1:14 pm

    #1107544

    some reference material

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

    Unless you are dealing with SQL Express, then you might also want to read this about some limitations.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 7 posts - 1 through 6 (of 6 total)

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