Post reply

partition a table by date

  • August 26, 2010 at 12:31 am

    #237235

    Hi,

    I have some confusion about the partitioning of tables.is it possible to partition a table on the basis of date.

    I have table in which entry are done on the basis of date. and each date have the 40000 entry.i m facing the problem while fetching the data. i think if i create the partition on the table then may be performance can be increased.

    Please give me some idea about it.

    Thanks,

  • August 26, 2010 at 7:46 am

    #1212306

    Yes, you can partition a table based on a datetime field. You'll need to create a partition function that accepts a datetime value for the input parameter. Create a partition scheme (to map partitions to filoegroups), and ideally put those filegroups on different disks (for better performance), although that is not absolutely necessary.

    ---------------------------------------------

    Note

    If boundary_value consists of datetime or smalldatetime literals, these literals are evaluated assuming that us_english is the session language. This behavior is deprecated. To make sure the partition function definition behaves as expected for all session languages, we recommend that you use constants that are interpreted the same way for all language settings, such as the yyyymmdd format; or explicitly convert literals to a specific style. For more information, see Writing International Transact-SQL Statements. To determine the language session of your server, run SELECT @@LANGUAGE.

    ---------------------------------------------

    Taken from

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply