Questions tagged as 'database-partitioning'

0
answers

What should I worry about when creating a partitioned table in SQL Server?

It was suggested to partition the main table of my system to improve the performance of some queries. The dev that made the suggestion suggested using the ano registry information to partition, because as the system has not been runnin...
asked by 09.03.2018 / 17:05
0
answers

Partitioning MYSQL tables

Good night everyone. I have a question regarding tables in mysql. Assuming the following scenario. I have a MYSQL INNODB table with PK ID INT UNSIGNED. (4 billion records approx) 1 º If by chance I reach the registry 4,294,967,295.00...
asked by 20.06.2018 / 23:48
0
answers

SSAS Process.Add Calculated vs. Non-Calculated Partitions

I was trying to Process.Add my SSAS Database via TMSL following the instruction of this URL: ProcessAdd with TMSL Script    The JSON DDL request failed with the following error: Failed to   execute XMLA. Error returned: 'A Refresh reques...
asked by 20.06.2018 / 14:35