About sql server capability

• Jeba_Antony

  SSC Enthusiast

  Points: 171

  More actions

  April 26, 2007 at 4:56 am

  #178047

  Hi,

  In my application i have to stored large number of data's in my tables minimum 1 lakhs per table. I am using SQL Server 2005 Management Studio for this application.

  How can i develop the efficient query manipulation from this large data.

  pls advice

  Regards

  Antony

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  October 17, 2007 at 5:30 am

  #742668

  Several hundred thousand rows per table will not present much of a challenge to SQL Server 2005.

  How frequently will the data be modified? What are the general use cases? Have you given any thought to your indexing/partitioning strategy, yet?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com