SQLServerCentral.com / SQL Server 2008 / SQL Server 2008 Administration / How to Check Partition is Working or not / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 12:16:53 GMT20RE: How to Check Partition is Working or nothttp://www.sqlservercentral.com/Forums/Topic1470626-1550-1.aspxHiMaybe following link [url]https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/[/url] will enclear some things to you.Fri, 05 Jul 2013 08:37:38 GMTIgor MicevHow to Check Partition is Working or nothttp://www.sqlservercentral.com/Forums/Topic1470626-1550-1.aspxHi All,In a database (partitionDB) I have created partition then I have crated table on that DB. In another database (Partitiondb_New) I have the same table but here is no partition. In both the datbases there is a table 'Orders'.I have used the following query to partition the database (partitionDB)[quote]Create PARTITION FUNCTION PFORDERDATERANGE (DATETIME)ASRANGE RIGHT FOR VALUES ('2011-05-04','2011-08-04','2011/11/04','2013/01/04','2013/04/04','2013/07/04')Create Partition Scheme PSOrderDateChange as Partition PFORDERDATERANGE to (FG1, FG2, FG3, FG4, FG5, FG6, [Primary])Create table dbo.orders(Orderid int identity (1,1) not null,[Orderdate] [datetime] not null,[Name] nvarchar (255),[Productid] int null,constraint [pk_orders] primary key clustered ( Orderid ASC, Orderdate ASC )ON PSOrderDateChange (OrderDate))on PSOrderDateChange (OrderDate)[/quote]Lastly I have checked to see which filegroups contain how may records[quote]select $partition.PFORDERDATERANGE (o.orderdate) as [Prtition Number],Min(o.orderdate) as [Min Value],max (o.orderdate) as [Max Value],Count(*) [records in Partition]from Orders oGroup by $partition.PFORDERDATERANGE (o.orderdate)order by [Prtition Number][/quote]and I am getting result. to see the result and performance issue I ran a query in both the databases[quote]select * from dbo.Orderswhere Orderdate between '2013-01-04 00:00:00.000' and '2013-04-03 00:00:00.000'[/quote]but in both the scenario I am getting output in 8 secs....then How will I use partition in my database or table?I am sure someone will show the right direction....Thanks in advanceFri, 05 Jul 2013 02:40:19 GMTniladri.primalink