| Author |
 Topic  |
|
|
PadLing
Starting Member
2 Posts |
 Posted - 02/27/2013 : 04:00:37
|
Hi All,
New to partition function. I ran a trace and used DB tuning wizard to get some recommendations. One of which was a partition function as follows
CREATE PARTITION FUNCTION [_dta_pf__4364](varchar(50)) AS RANGE LEFT FOR VALUES (N'214', N'249', N'50000', N'66767')
CREATE PARTITION SCHEME [_dta_ps__8066] AS PARTITION [_dta_pf__4364] TO ([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
All the partitions are created in the Primary and should I need to change the Stored Proc to get data from different partition.
Also, how to remove the partition .
Kindly help.
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48012 Posts |
Posted - 02/27/2013 : 04:11:38
|
yep...recommended approach is to associate partitions to different filegroups
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
PadLing
Starting Member
2 Posts |
Posted - 02/27/2013 : 04:37:58
|
Hi,
Thanks, but if the recommended script is with only the PRIMARY filegroup, can I simply execute it.
If I do so, do I need to change the stored procs to collect from the PRIMARY Partition.
Thanks
Pad
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48012 Posts |
Posted - 02/27/2013 : 04:42:22
|
nope if you want them to be in different filegroups you need to replace PRIMARY with correct filegroup names in above statements
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srimami
Posting Yak Master
152 Posts |
Posted - 02/28/2013 : 11:16:27
|
"Thanks, but if the recommended script is with only the PRIMARY filegroup, can I simply execute it."
by default it will take primary but it is always advisable to have on different file groups. |
|
|
| |
Topic |
|
Partition Function
