InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 16:12:42 GMT20http://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxgood one.. new thing to knw abt partioningTue, 11 Dec 2012 03:06:34 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxThere are two facts needed to answer this question correctly:1) RANGE LEFT is the default.2) Partitions start numbering at one, not zero.I was only half-way there.Mon, 11 Aug 2008 09:49:00 GMTFesteronhttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxNew thing to learn. Thanks.....:)Mon, 11 Aug 2008 02:14:30 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxActually, Chad, knowing that, I would have worded the question to include that data. Minor nitpick, but legit. Not my question, but would have worded it with that in mind if it were mine.Fri, 08 Aug 2008 14:52:27 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxHmmm... I got the error below, which wasn't one of the options, so I couldn't select it:[code]Msg 7736, Level 16, State 1, Line 2Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.Msg 208, Level 16, State 80, Line 1Invalid object name '$partition.PartitionFunction1'.[/code]:P got it right anyway. :PChad(yes, yes, I know.... adding this as an option would have destroyed the point of the question.)Fri, 08 Aug 2008 09:20:57 GMT Chad Crawfordhttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxThanks for the link, that was helpful.Fri, 08 Aug 2008 07:21:51 GMTCliff Joneshttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxIt's used in setting up table & index partitioning.A nice article on this topic:[url]http://technet.microsoft.com/en-us/library/ms345146.aspx[/url]Fri, 08 Aug 2008 00:58:12 GMTLian Pretoriushttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxHi all,What exactly is the Partition Function.Regards,Fazal.Fri, 08 Aug 2008 00:27:34 GMTfazal.shaikhhttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxHi,When in real life the partition function is used?Thanks & regards,SSThu, 07 Aug 2008 23:46:28 GMTsheetalshhttp://www.sqlservercentral.com/Forums/Topic548855-34-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/63689/">Partition Functions</A>[/B]Thu, 07 Aug 2008 22:48:32 GMTSite Owners