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.
| Author |
Topic |
|
PadLing
Starting Member
2 Posts |
 Posted - 2013-02-27 : 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 followsCREATE 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
52326 Posts |
Posted - 2013-02-27 : 04:11:38
|
| yep...recommended approach is to associate partitions to different filegroups------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
PadLing
Starting Member
2 Posts |
Posted - 2013-02-27 : 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.ThanksPad |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-27 : 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-28 : 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. |
|
|
|
|
|
|
|
|
Partition Function