<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Development
»
Partitioned Tables
Partitioned Tables
Rate Topic
Display Mode
Topic Options
Author
Message
munnaonly
munnaonly
Posted Monday, February 25, 2013 2:27 AM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 6,
Visits: 54
i 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.
Post #1423500
joeroshan
joeroshan
Posted Monday, February 25, 2013 2:32 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:45 AM
Points: 572,
Visits: 1,157
Just 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 help
-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1423503
GilaMonster
GilaMonster
Posted Monday, February 25, 2013 2:41 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 37,651,
Visits: 29,903
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1423506
munnaonly
munnaonly
Posted Monday, February 25, 2013 3:42 AM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 6,
Visits: 54
Thanks for updating,
But, I have duplicate values in date column,
Post #1423526
munnaonly
munnaonly
Posted Monday, February 25, 2013 4:49 AM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 6,
Visits: 54
i go through the link
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
Post #1423542
GilaMonster
GilaMonster
Posted Monday, February 25, 2013 4:54 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 37,651,
Visits: 29,903
munnaonly (2/25/2013)
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
See the article I referenced.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1423547
munnaonly
munnaonly
Posted Monday, February 25, 2013 10:55 PM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 6,
Visits: 54
Yes, i referred the article, but i haven't see difference, is any other setting there ?
Post #1423883
GilaMonster
GilaMonster
Posted Tuesday, February 26, 2013 3:11 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 37,651,
Visits: 29,903
munnaonly (2/25/2013)
Yes, i referred the article, but i haven't see difference, is any other setting there ?
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?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1423965
munnaonly
munnaonly
Posted Tuesday, February 26, 2013 11:40 PM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 6:28 AM
Points: 6,
Visits: 54
Column_name Type
Column1 bigint
Column2 bigint
Column3 varchar
Column4 bigint
Column5 varchar
Column6 bigint
Column7 varchar
Column8 bigint
Column9 varchar
Column10 bigint
Column11 varchar
Column12 bigint
Column13 varchar
Column14 varchar
Column15 bigint
Column16 bigint
Column17 bigint
Column18 numeric
Column19 datetime
I Have Partitioned on cloumn 19, below are the space used details for the 'Table1' and partition details
name rows reserved data index_size unused
Table1 13056988 2512632 KB 2503320 KB 8800 KB 512 KB
name partition_number rows
Table1 1 2417
Table1 2 2665897
Table1 3 2676153
Table1 4 2711158
Table1 5 2688720
Table1 6 2312546
Table1 7 97
Table1 8 0
Table1 9 0
Table1 10 0
Post #1424349
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
