The table-partitioning tag has no wiki summary.
0
votes
1answer
21 views
In partition definition filegroup name appears twice, what does that mean?
short question regarding partitions, consider the following partition definition:
CREATE PARTITION SCHEME [MSAppServerPS_ASWcfEventsTable] AS
PARTITION [MSAppServerPF_ASWcfEventsTable] TO ...
0
votes
1answer
36 views
How to do Partition for MySQL 100GB table in zero downtime?
I have a Innodb engine table with 100GB,I have a planned to do partition the table.Can anyone tell me how to do it in zero downtime?
In 100GB table the records are increasing for each and every ...
0
votes
0answers
36 views
Moving Data between Partitions [closed]
I have partition on my database up to 2013 and this partition contains >= 2013 records.
Now I have test table which have more than 2013 records so I have created 2014 File and filegroup and add ...
1
vote
1answer
29 views
Partition Function with only one value, what does this effect?
I am currently looking at a database that has been setup by the default installation routine of AppFabric. Looking at the creation scripts I encountered this partition function:
CREATE PARTITION ...
0
votes
1answer
34 views
SELECT to only see Offsetting Transactions in table?
I have a temp table like this
I have been playing with it but I don't know how to get same PortCode,Cusip combo to give me only offsetting transactions (Buy,Sells) not (Purchase,Purchase) combos.
...
0
votes
0answers
75 views
Incorrect information in .frm file after a power outage?
CentOS release 6.3 (Final)
x86_64
mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1
SHOW SLAVE STATUS\G:
Slave_IO_Running: Yes
Slave_SQL_Running: No
...
5
votes
2answers
164 views
How to partition an existing non-partitioned table
I have an existing table with data:
dbo.Test (col1,col2,col3....) ON [PRIMARY]
I need to change this table to be partitioned like this:
dbo.Test(col1,col2,col3....) ON Ps_Date(Col2)
How I can I ...
2
votes
1answer
46 views
MySQL table architecture
Background information:
I have a table containing upload information, every day I get more and more uploads but most of the queries I run center around information gathered within the last 12 months; ...
1
vote
1answer
99 views
MS SQL Server 2005 DB backup with partitioned tables to non-partitioned SQL Server 2012
I have a database with several partitioned tables on MS SQL Server 2005 Enterprise, and I have to restore this DB on MS SQL Server 2012 Standard. Since Standard doesn't support partitioning - it's a ...
2
votes
2answers
100 views
Partitioning a multi-terabyte database [closed]
We have a database which is nearly 3TB in size, out of which 8 tables together are 1.5TB which we want to partition based on year.
But as we will be partitioning over a terabyte of data, this will be ...
0
votes
0answers
17 views
Solving Page_Latch wait on Date based Partition Table
I need something like the proposed solution in below link, but it was based on INT column not on DateTime.
...
0
votes
0answers
15 views
MySQL Partitioning without specifiying any properties for partition
I have a quite huge MySQL table. In my table I have date field. Recently I created another field called YearMonth which get year from date, multiple it to 100 and adds the month from date table to it. ...
5
votes
0answers
122 views
Strategy to deal with multi billion row simulation results and partitioning
I am trying to come up with a good way to deal withthe results of statistical simulations from a dba point of view. We generate about 500 million rows per day, most of which are "garbage" (i.e. the ...
