sql server 2005 Table Partitioning

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  February 17, 2010 at 2:30 am

  #138275

  hi,

  Is it beneficial by using single drive ( lets say D drive), and multiple file groups on same drive ( in my case D drive).

  i have created database with primary file group. Now i want utilize paritioning functionality. And i have created two more file groups in same drive. If i use the partition for a table will be good or old is good?

  or it can be possible and advantageous by using primary only for the partiotions.

  How it will be useful to a query?

  🙂

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 17, 2010 at 3:33 am

  #1119931

  I would suggest using a seperate drive(s) for it will increase your performance.

  http://msdn.microsoft.com/en-us/library/dd758814.aspx

  http://msdn.microsoft.com/en-us/library/dd758814.aspx

  http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx

  http://serverfault.com/questions/19866/recommended-disk-partition-setup-for-a-sql-server

  http://databases.about.com/od/sqlserver/a/partitioning.htm

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/