partitioning in sql server 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

partitioning in sql server 2000

Author

Topic

pmotewar
Yak Posting Veteran

62 Posts

Posted - 2009-06-29 : 08:58:42

Hi all,

i just want to know
can we use partitioning in sql server 2000.

if yes then how ? or plz provide any link

Pankaj

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-29 : 09:06:32

It depends if you want horizontal partitioning or vertical partitioning.

Enterprise Edition has built-in partitioning (hard partitioning).
See http://weblogs.sqlteam.com/peterl/archive/2008/06/12/Horizontal-partitioning-Enterprise-style.aspx

Other Editions must be programmed to this (soft partitioning).
See http://weblogs.sqlteam.com/peterl/archive/2007/09/24/Horizontal-partitioning.aspx

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources