Partitioning Tables (Sql Server 2005)

• gogia.jaswinder

  Mr or Mrs. 500

  Points: 506

  More actions

  October 14, 2008 at 4:20 pm

  #194575

  Hi Guys

  I have a table with approximately 5 Million of records in it and data need to select the daily by different groups of people as data been submitted by 1200 people weekly basis.

  we have sql server running across the region with sql server 2000 replication. But data is coming out slowly.

  I am wondering If I am shifting my data to SQL Server 2005 with Partitioning scheme, will it affects to performance.

  Thanks

  jaswinder

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  October 14, 2008 at 5:24 pm

  #884960

  Generally speaking, partitioning will help performance. The key is that you need a logical, consistent data point on which to partition.

  If you need to stick to 2000, you can look at partitioned views.

  You may want to spend some time here: http://sqlcat.com/