?
Solved

Insert query

Posted on 2011-02-15
7
Medium Priority
?
1,419 Views
Last Modified: 2012-06-27
Hello
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 ?


Sham
0
Comment
Question by:mohet01
  • 3
  • 2
  • 2
7 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34903016
I suggest you check out:
http://msdn.microsoft.com/en-us/library/ms143432.aspx

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?
0
 
LVL 78

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
0
 
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
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

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

0
 
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
0
 
LVL 78

Accepted Solution

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

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

http://msdn.microsoft.com/en-us/library/ms143432(v=SQL.90).aspx
0
 

Author Closing Comment

by:mohet01
ID: 34912762
Done
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

850 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