The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
11 views

SQL Server Table Partitioning & Impact of Raid Levels

How does SQL Server Table partitioning get impacted by the DISK RAID level ? We have a SQL Server with 8 data disks . The main table in the database has over 200 million rows partitioned by day of ...
0
votes
1answer
345 views

How to restore a saved partition table to another disk with parted

OS: Ubuntu 10.04 I have saved my partition layout from sda and want to restore it to my new disk sdb. I have used the following command to save the layout, but how can i restore it to my new disk ...
0
votes
1answer
159 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
67 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
237 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
313 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
462 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 ...
7
votes
1answer
1k 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
51 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
434 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
808 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 ...