SQL Server Partitioning - Notion -

-

i have got database consisting of several thousand of tables (from 2005) 20-30% of them have incremental rowcount of 200k/yr.

the requirement visualize statistics of table based on column lastaccesseddate. scheme classify parition groups (10 y, 5y, 3y, 1y, 6m, 3m, 1m, 2w, currentdate). partitions named p1,p2,..p10

i able understand multiple partitionining groups can defined tables link.

the job runs every week , therefore, partitioning scheme varies on current date; i.e. after week, p10 becomes p9. after 2 weeks, p9 becomes p8 , after month, p8 becomes p7; hope idea.

  1. is partitioning scheme based on current date feasible?
  2. if feasible, worthwhile horizontally partition tables , query them instead of running query through entire table? sql server reports suggests total space usage around 31,556 mb.

i running on sql server 2008 instance.

you mention data storage , statistics requirements. these 2 should not confused. storage solutions made quick access of data, , statistics in domain of reporting , visualisation.

with respect storage should use partitioning, not in proposed way. can have 10.000 partitions in sql server, use one day or one week usefull partition key. once created can switch sections in , out of partitioned table, should not move data existing partition partition, implies recalculation constraints , indexes. in views can create additional values later 'group by' actions. these groups can describe required '1d, 1w, 1m, 1q, 1y' reporting values.

so yes it's feasible , recommended use partitions case, in different way proposed.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more