partition table

• mpradeep23

  SSCommitted

  Points: 1868

  More actions

  May 3, 2013 at 5:24 am

  #277343

  hi

  can we partition on last modified date

  thanks

  with best regards

  pradeep

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  May 3, 2013 at 12:49 pm

  #1612314

  Yes you can create partition on date column.

  refer to :-

  http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  May 3, 2013 at 1:11 pm

  #1612322

  Just curious, why are you choosing to add partitioning to your table?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato