SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / Can we have same Partition function and Partition Scheme to all the tables in a schema ? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:43:40 GMT20RE: Can we have same Partition function and Partition Scheme to all the tables in a schema ?http://www.sqlservercentral.com/Forums/Topic1404372-391-1.aspxYou can. Whether it's a good idea or not, only you can tell that.Partitioning is something that must be tested thoroughly before implementing. If the partitioning key is not used frequently in your queries, the overall performance could get worse than what you get on the non-partitioned tables.Wed, 09 Jan 2013 01:41:41 GMTspaghettidbaCan we have same Partition function and Partition Scheme to all the tables in a schema ?http://www.sqlservercentral.com/Forums/Topic1404372-391-1.aspxCan we use same Partition function and Partition Scheme to all the tables in a schema ?Tue, 08 Jan 2013 10:28:39 GMTSQListic