SQL server -----IF we have lot of records in Database. How we can handle them? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. 开发者_如何学JAVA Closed 12 years ago.

IF we have lot of records in Database. How we can handle them?

---

Doesn't matter how much data you have, SQL Server will handle itself :).

And if you are talking about performance -

1. Make sure that your are using proper indexes
2. Check your sql queries, they should be optimized.

---

If you are asking about managing large data in the database tables for this in SQL there is a feature called data partitioning. For this you can check this http://www.mssqltips.com/tip.asp?tip=1200

---

• Shrink your database by schedule
• Check the log file size or delete if unnecessary.