MSSQL server 2005 database tables capacity

Question

0.00/5 (No votes)

See more:

please tell me if frequently I am inserting data in table of MSsql approx 25000 records per day, and total rows in a table are 25,00,000. So in this case is any chance of loss or fail to insert data in sql table/database ????

Posted 5-Sep-11 23:25pm

siddhai12

Add a Solution

Comments

Reiss 6-Sep-11 5:54am

I can't stress this enough, but make sure your that all indexes and stored procedures are properly maintained otherwise your db perfromance will suffer.

As a minimum always recompile your sp's if you change any of the indexes/statistics for pre SQL 2008

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2011-09-05T23:37:00

Solution 1

Sql server is unlimited by row count, although if you are using int primary keys you are limited to 4 billion rows before you can't access them.

The main limit is when you are using Sql Express which is limited to 4gb database file (2008 has up'ed it to 10gb).

Posted 5-Sep-11 23:37pm

Mehdi Gholam

Comments

Wendelius 6-Sep-11 6:22am

Exactly, my 5

Wendelius · Accepted Answer · 2011-09-06T00:22:00

As Mehdi pointed out, there's plenty of room, at least if you use Standard or Enterprise Edition.

Few things to note:
- the risk of data loss isn't dependent on the amount of data. You always have the risk, prepare for it
- create a good backup plan and implement it
- ensure that the performance is adequate even with high workload, concentrate on reasonable indexing
- if lots of rows are queried, ensure that you have enough memory
- take care of sql reusing