September 15, 2010 at 11:35 pm
After implementing table level partioning, how to verify if the partitioning is really implemented. That is, after you enter appropriate values based on partition range, I want to verify if the entered values are going to the correct partition.
Please share your inputs.
M&M
September 16, 2010 at 12:31 am
Hi
Mohammad let us know u done the Vertical OR Horisental partitioning.
and In my opinion issue a select query to know where apropriete data entered?
Ali
MCTS SQL Server2k8
September 16, 2010 at 12:32 am
It is horizontal partitioning. But from select statement, how do we know?
M&M
September 16, 2010 at 12:40 am
hi
visit
http://blogs.msdn.com/b/craigfr/archive/2008/07/15/partitioned-tables-in-sql-server-2008.aspx
Ali
MCTS SQL Server2k8
September 16, 2010 at 12:43 am
use the sys.partitions view
for detail can be found in http://www.sqlservercentral.com/articles/partition/64740/
"More Green More Oxygen !! Plant a tree today"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply