InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 18:27:15 GMT20http://www.sqlservercentral.com/Forums/Topic1368590-338-1.aspxHi Abhishek,I am assuming the mail target of this partition is to fetch the query fast.So use those values which are frequently used in your Where clause.You can use Date column or Year column also for this.Sun, 07 Oct 2012 12:24:31 GMTRajat Jaiswal-337252http://www.sqlservercentral.com/Forums/Topic1368590-338-1.aspxI have a table(T1) of around 20 million record and about to grow in future by 100 to 200%. It contains the Data for the respective day and on next day it will be stored into another table (backup tables (T1_Backup)). And the process continues.My queries are1) T1 table is used to generate report for the respective date. I am thinking to partition the table with respective to category column (which is varchar datattype). 2) T1_Backup table is also containing data of each date with category which grows rapidly. To retrieve data from the table it is consuming lot of time. Let me know the process of partitioning with respective of category for T1 table and for T1_Backup wrt to date and category.Thu, 04 Oct 2012 11:05:32 GMTav.abhishek