Insert query

Posted on 2011-02-15
Last Modified: 2012-06-27
1) is there a limit in the number that can be inserted in a ms sql table?
How do I know, if there is a limit?
Because there is a scenario where I have 170000 entries in a table, I would like what are the factors that decides the limit?
2) if there is a limit, what happens when you add an additional entry, does this raise any windows error on windows event/app/system logs ?

Question by:mohet01
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34903016
I suggest you check out:

What do you mean by "number that can be inserted"?  Maximum number of rows, or the max size of the actual 'number' or something else?
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34903019
If I read your question right, you are asking about the number of rows.  From the link I provided:

Rows per table  Limited by available storage
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 34903078
depends on the space available on the disk.
Now, if you want to insert such a large volume of data, i suggest use the BULK INSERT /bcp statements (also change the mode to 'bulk logged' otherwise each insert statement will make the log files to grow
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.


Author Comment

ID: 34903637
maximum nuber of rows that can be inserted in a SQL 2005 table?

LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 34903685
>maximum nuber of rows that can be inserted in a SQL 2005 table?

depends on the free space and edition, the express edition have a database size limit of 4gb
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 250 total points
ID: 34907001
As already posted:  Rows per table Limited by available storage

Using the link I posted, select 'Other Versions', select 2005.

Author Closing Comment

ID: 34912762

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question