InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 00:29:29 GMT20http://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspxColumn_name TypeColumn1 bigintColumn2 bigintColumn3 varcharColumn4 bigintColumn5 varcharColumn6 bigintColumn7 varcharColumn8 bigintColumn9 varcharColumn10 bigintColumn11 varcharColumn12 bigintColumn13 varcharColumn14 varcharColumn15 bigintColumn16 bigintColumn17 bigintColumn18 numericColumn19 datetimeI Have Partitioned on cloumn 19, below are the space used details for the 'Table1' and partition detailsname rows reserved data index_size unusedTable1 13056988 2512632 KB 2503320 KB 8800 KB 512 KBname partition_number rowsTable1 1 2417Table1 2 2665897Table1 3 2676153Table1 4 2711158Table1 5 2688720Table1 6 2312546Table1 7 97Table1 8 0Table1 9 0Table1 10 0Tue, 26 Feb 2013 23:40:09 GMTmunnaonlyhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspx[quote][b]munnaonly (2/25/2013)[/b][hr]Yes, i referred the article, but i haven't see difference, is any other setting there ?[/quote]Errr... the entire first section of that article explains why partitioning does not get you an automatic performance improvement and what the point of partitioning is. What 'other setting' are you looking for?Tue, 26 Feb 2013 03:11:54 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspxYes, i referred the article, but i haven't see difference, is any other setting there ?Mon, 25 Feb 2013 22:55:55 GMTmunnaonlyhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspx[quote][b]munnaonly (2/25/2013)[/b][hr]it is really fun !!, After partitioned, i observed it is time taken in Partitioned tables compared "Un Partitioned" Table.Can you please help on this, if any thing i missed here[/quote]See the article I referenced.Mon, 25 Feb 2013 04:54:18 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspxi go through the linkit is really fun !!, After partitioned, i observed it is time taken in Partitioned tables compared "Un Partitioned" Table.Can you please help on this, if any thing i missed hereMon, 25 Feb 2013 04:49:54 GMTmunnaonlyhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspxThanks for updating,But, I have duplicate values in date column,Mon, 25 Feb 2013 03:42:28 GMTmunnaonlyhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspx[url]https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/[/url]Mon, 25 Feb 2013 02:41:28 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspxJust by partitioning we cannot be sure to get performance benifit.You should look at your queries and execution plans and see partition elimination is happening.look at your frequent / long running queries and share the execution plan if you need further helpMon, 25 Feb 2013 02:32:08 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic1423500-145-1.aspxi have one table it contains 30 million records, Now I have partitioned the Table, I could not find much difference in the data retrieval speed.Mon, 25 Feb 2013 02:27:49 GMTmunnaonly