Prev: Backups sequence
Next: Using Machine Name in DOS Batch
From: SQL on 29 Jun 2010 18:56
Can someone give practical guidelines on how and when the data
partition to be used? I am looking for a specific pointers such as how
many cols (??) are too many to start looking at vertical partinioning
and how many rows (counts) are too many for a horizontal paritioning?
What is the performance criteria be considered for partitioning?
From: John Bell on 2 Jul 2010 18:22
On Tue, 29 Jun 2010 15:56:14 -0700 (PDT), SQL <texassqldba(a)gmail.com>
wrote:

>Can someone give practical guidelines on how and when the data
>partition to be used? I am looking for a specific pointers such as how
>many cols (??) are too many to start looking at vertical partinioning
>and how many rows (counts) are too many for a horizontal paritioning?
>What is the performance criteria be considered for partitioning?

Hi

I don't think there is a hard rule for this, you have to look whole
picture i.e the data, hardware, applications and how they are
used/designed

This may help:
http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx#sql2k5parti_topic1

John




From: Uri Dimant on 5 Jul 2010 00:48
http://www.mssqltips.com/tip.asp?tip=1621
http://blogs.msdn.com/craigfr/archive/2006/11/27/introduction-to-partitioned-tables.aspx
http://www.simple-talk.com/sql/sql-server-2005/partitioned-tables-in-sql-server-2005/





"SQL" <texassqldba(a)gmail.com> wrote in message
news:50750990-4c6a-4ff6-9dc8-82afa02192c6(a)j8g2000yqd.googlegroups.com...
> Can someone give practical guidelines on how and when the data
> partition to be used? I am looking for a specific pointers such as how
> many cols (??) are too many to start looking at vertical partinioning
> and how many rows (counts) are too many for a horizontal paritioning?
> What is the performance criteria be considered for partitioning?


 | 
Pages: 1
Prev: Backups sequence
Next: Using Machine Name in DOS Batch