You will have to do poor man's partitioning in Standard Edition. It is,
obviously, not true partitioning but you can get physical separation of
records based on a constraint-able column as part of the primary key and
then a view that wraps up the tables to appear as a single entity.

For example, I have a Task entity. This can be either open or closed so
the tables are broken up into TaskOpen and Task Closed. The IsClosed
(BIT) column has a constraint on it that is false for TaskOpen and true
for TaskClosed. Adding this column to a composite primary key and using a
non-computed value for the other primary key column allowed me to have a
UNION view (Task) that when INSERT, UPDATE is performed it automatically
goes to the correct table because of the constraint. More importantly,
when running a user's queue part of the clause is IsClosed=0 which forces
the database engine to only look at the TaskOpen table because that value
can never exist in TaskClosed and performance is improved.

-Dave




"Satish" <mssqldba-ezmlmshield-x16961698.[Email address protected]
03/31/2008 04:34 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE:Partition







even i would be interested in same.

Thanks & Regards,
Satish Sharma,
Information Technology-Kamala Mills.
HDFC Bank Ltd.
[ Kamala Mills : 24910492 Extn : 3075 ]
Visit us at www.hdfcbank.com





"Ramesh K "
<mssqldba-ezmlmsh
ield-x46231265.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
31/03/2008 12:48
Subject
RE:Partition










Hi All,
Pls tell me whether Table Partitioning is possible in Standard
Edition.

Thanks
K.Ramesh





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page