The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
47 views

“Can't create table” when having to many partitions

I am currently having a problem I dont understand. Wherever I look it says mySQL (5.5) / InnoDB doesnt have a table limit. I wanted to test the InnoDB compression and was about to create an empty ...
0
votes
0answers
46 views

SQL Server Table Partitioning and my data lifetime management

My application stores data on Enterprise edition sql server, and I plan to take advantage of table partitioning to manage data retention. Each partition will hold a predefined period of time (say one ...
0
votes
1answer
191 views

Partition PostgreSQL table based on FK attribute

I want to parition my huge table to solve a performance issue, but the attibute on which I want to parition my table resides in another table that is related by FK. Here are my tables: Article ...
1
vote
1answer
261 views

SQL Server Partitioning, best practices for creating partition scheme's and functions

I'm implementing Partitioning for the first time in SQL Server 2008r2. I've several large tables that I am partitioning. My main question is should I use the same Partition Scheme and Function for ...
1
vote
1answer
338 views

SQL Server 2008 SP1 Transactional Replication of a Partitioned Table Generates StackDump

I have a partitioned table that is published for transactional replication. The SWITCH operations on this table appears to replicated to the subscriber even though the options to ...
3
votes
1answer
850 views

Speed up MySQL inserts with partitions on MyISAM with unique key

I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on ...
0
votes
1answer
49 views

SQL2008R2 Partitioning query

We have a complex query that returns results in 45 secs when run from the 01-05-11 to the 31-05-11, but when it is extended to the 01-06-11 it runs indefinately... THe tables are partition by ...
0
votes
1answer
100 views

How to get optimal drive performance for a DB on SQL Server 2008 R2 Enterprise Ed.?

So I am pretty green when it comes to hardware configurations. I just asked a coworker and he said we're using RAID 60 (I assume is the same as RAID 6+0). I am doing some tests on a large table (1 ...
0
votes
1answer
2k views

How does rebuilding partitioned table index affect table access?

RDBMS: SQL Server 2005 Standard Edition I have a table with 1 billion rows. What I would like to do is to vertically partition it with a partition function and apply a partition scheme with the ...
0
votes
3answers
411 views

Partition 500gb of database stored in SQL Server

I have 500GB of database stored in SQL Server. Because it has too big a database, it takes time to update and insert data. Now the case is that I want to partition the data. So which partitioning ...
1
vote
2answers
801 views

Easy Table Partitioning in SQL Server 2005 for Fact Tables?

I've been reading the article at http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx in preparation for implementing some partitioning. I have several tables I want to partition on a ...