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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

705 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