table partitioning limitations

Question

Post reply

table partitioning limitations

parissa_bakhshi

Ten Centuries

Points: 1388
More actions
December 4, 2011 at 6:28 am

#248954

Hi,
Wonder to know the limitations of partitioned table if any exists. Could anyone help me?
Have fun,
Parissa

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63498 More actions · Answer 1

Do you mean aside from the fact that it requires the Enterprise version of SQL Server?

LutzM SSC Guru Points: 107049 More actions · Answer 2

What do you consider as "limitations"?

Would the fact count, that a query with a WHERE clause that covers more than one partition might run significantly slower than against a properly indexed, but unpartitioned table?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

LutzM SSC Guru Points: 107049 More actions · Answer 3

jonangela571 (12/4/2011)
Hello all my friend. I am new member

Spam. Reported. No replies please.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

LutzM (12/4/2011)
What do you consider as "limitations"?
Would the fact count, that a query with a WHERE clause that covers more than one partition might run significantly slower than against a properly indexed, but unpartitioned table?

Also,

Partitions per partitioned table or index: 1,000

Per: http://msdn.microsoft.com/en-us/library/ms143432.aspx

(I remember one article which indicates it can go upto 15K partitions per table but not able to find that one.)

parissa_bakhshi Ten Centuries Points: 1388 More actions · Answer 5

Dev (12/5/2011)
LutzM (12/4/2011)
What do you consider as "limitations"?
Would the fact count, that a query with a WHERE clause that covers more than one partition might run significantly slower than against a properly indexed, but unpartitioned table?
Also,
Partitions per partitioned table or index: 1,000
Per: http://msdn.microsoft.com/en-us/library/ms143432.aspx
(I remember one article which indicates it can go upto 15K partitions per table but not able to find that one.)

Yeap, I meant things like this. Like mirroring, it's not good for more that 22 databases, or "linked servers" which have problems with XML, I want to know the limitations before making decisions about choosing it in enterprise level.

Things like what you said about slower WHERE clause, is of high importance to me.