partitioning_开发者

Time to archive - SQL Server

I am researching archiving options for our database application (highly normalized schema) and would appreciate expert feedback.We are using Sql Server 2005, but if something works only in 2008 R2 tha[详细]

2023-04-12 10:10 分类：问答

partition of a list using dynamic programming

I have posted a bit here related to a project I have been trying to work on and I keep hitting design problems and have to design from scratch.So I\'m wondering if I can post what I\'m trying to do an[详细]

2023-04-11 16:36 分类：问答

MongoDB sharding/partitioning 100+ million rows in one table on one machine

Does MongoDB support something akin to ordinary database partitioning on a single machine?I’m looking for very fast queries (writes are less important) on a single large table on one machine.[详细]

2023-04-10 14:01 分类：问答

Partitioning by Year vs. separate tables named Data_2011, Data_2010, etc

We are designing a high volume SQL Server application that involves processing and reporting on data that is restricted within a specified year.[详细]

2023-04-07 22:25 分类：问答

how to sort multiple sorted data set from DB in C#?

I have a partitioned table in SQL SERVER, there is a clustered index on ID, and the table is partitioned by period_key. The ID is uniqu开发者_运维技巧e inside partition, but not unique cross partition[详细]

2023-04-07 15:59 分类：问答

Is it worth to partition a MySQL table on a key, if this key is already an index?

I have a big MySQL table (around 50 GB, tens of millions of records), with one index key (a foreign key) that has around 2000 possible d开发者_开发百科ifferent values, and another index key (a VARCHAR[详细]

2023-04-03 19:01 分类：问答

Programatically change FAT32 volume serial number

How do I programatically change Volume Serial of a Fat32 partition from C#. I found this example, but it is written with C++ which I don\'t read well. Could someone please answer a C# code snippet?[详细]

2023-03-31 09:24 分类：问答

Spring Batch custom partitioner for input file

I\'m trying to partition a flat input file containing ; separated items. the first item on a line indicates a category and I would like to partition on this category so that for each category a partit[详细]

2023-03-30 03:08 分类：问答

How to optimize oracle query from partitioned table?

I have a partitioned table by date (by days) and a local index on the fields (including date field). If I make a query:[详细]

2023-03-29 03:25 分类：问答

Can I skip a specific partition when querying an oracle table?

The reason behind this is that I have a known bad partition. I am trying to continue working with the database while the broken开发者_JS百科 partition is fixed by the DBA. There is of course more info[详细]

2023-03-28 19:38 分类：问答