Solved

Insert query

Posted on 2011-02-15
7
1,405 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 76

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 76

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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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 76

Accepted Solution

by:
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.

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

Author Closing Comment

by:mohet01
ID: 34912762
Done
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now