sudhirnune (6/8/2013)
Additionally, is there an index on the field you're looking to partition across? I'm wondering if the statistics are just wildly off. If there's an index on that field, UPDATE STATISTICS WITH FULLSCAN the table and see what kind of estimates you get.> No Indexed are on the table
Sorry, fell off the earth a bit on this. You have no indexes? No wonder you can't get a good estimate. If this table is a heap you're not going to get any performance increases from partitioning, you're aware of that, right?
Partitioning is more an administrative tool to ease data manipulation, not an optimization tool.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA