Stack Overflow
Stack Overflow

Questions tagged [partition]

Use this tag for questions about code that partitions data, memory, virtual machines, databases or disks.

In computing, partition may refer to

  • Disk partitioning, the division of a hard disk drive
  • Partition (database), the division of a database
  • Logical partition (virtual computing platform) (LPAR), a subset of a computer's resources, virtualized as a separate computer
  • Memory partition, a subdivision of a computer's memory, usually for use by a single job
  • Binary space partitioning

source: https://en.wikipedia.org/wiki/Partition

Note that non-programming questions about database partitioning are likely to be better received on Database Administrators and disk partitioning on Server Fault.

1547 questions
0
votes
1 answer

Considering size of an SQL Server DB / Table partition

The maximum possible database size of a SQL Server 2012 Web Edition is 524PB. What if I have tables partitioned in it? Can each table hold 524PB of data or should the sum of all table sizes (i.e. the actual db size) be 524PB?
user3747170
  • 1
  • 1
0
votes
1 answer

how to partitioning mysql by column value "user_id" and "gps_time"?

my table scheme: CREATE TABLE `test_table` ( `his_id` int(11) NOT NULL, `user_id` varchar(45) NOT NULL, `gps_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`his_id`,`user_id`) ) I want partitioning this table by user_id…
user1940483
  • 11
  • 4
0
votes
1 answer

Unable to access second partition on SD card

I want to place the odex files of data apps on the second partition on sd card(sdex2-FAT32 file system).But when I check for the existence of the folder on sdex2 with the script(posting only part of the script taken from other site), I always get…
Dario Dias
  • 817
  • 6
  • 19
  • 32
0
votes
3 answers

Using t-sql to lookup value based on dates in other table

I have the following challenge. I have 2 tables. First table contains changes in values of bikes, at a certain moment (i.e. price catalogue). This means a certain price for a product is valid untl there is a new price within the table. Product | …
Xivan
  • 5
  • 2
0
votes
1 answer

Recursive functions for partitions, stirling numbers, and chebyshev polynomials of the first

So I'm working on a homework assignment and I need to create recursive functions for partitions, Stirling numbers(first and second kind), and Chebyshev polynomials of the first. My program should be able to have a user input a positive integer n,…
Nisha Sharaschandra
  • 1
  • 2
0
votes
1 answer

Ranking over several columns

In the process of query optimization I got to following SQL query: select s.* from ( select id, DATA, update_dt, inspection_dt, check_dt RANK OVER() (PARTITION by ID ORDER BY update_dt DESC, DATA) rank FROM TABLE where update_dt < inspection_dt…
Omar Indegnos
  • 1
  • 2
0
votes
1 answer

Using query for table names in another query

I'm trying to query a database that has a strange manual partition scheme. The database has a partitions table defined as: CREATE TABLE [dbo].[partitions]( [pname] [varchar](255) NULL, [drvid] [int] NULL, [start_time] [bigint] NULL, …
cmwarre
  • 117
  • 1
  • 5
0
votes
1 answer

Check what partition is used?

I'm working on a SBC6845 card with Linux on it: I have 4 partitions installed: Creating 5 MTD partitions on "atmel_nand": 0x000000000000-0x000000100000 : "Factory" 0x000000100000-0x000000300000 : "Kernel1" 0x000000300000-0x000000500000 :…
hy0shi
  • 271
  • 4
  • 12
0
votes
3 answers

How to write Oracle Query with multiple statistics

How to get data using a single query with multiple aggregation calculation points. I have data like this.…
stoniel2
  • 93
  • 1
  • 2
  • 9
0
votes
1 answer

getting a specific row over a partitioned sql query

I know i can get first_value() and last_value() over partitioned sql query which is ordered by a column I know, but let's say I want the second value, or the third... Is there a function to do so? Thanks in advance.
user3688929
  • 23
  • 3
0
votes
0 answers

Attaching SQL Server database that is split into partitions

I have a trial version of SQL Server 2012 Enterprise on our test server that has expired. I would like to install a fresh copy of another Enterprise edition and attach the current db to the new one. I have done this locally by moving the mdf and ldf…
Konstantinos Papakonstantinou
  • 977
  • 3
  • 15
  • 33
0
votes
1 answer

How do i separate positive and negative numbers in a stack?

So I'm supposed to right a method in c that moves all negative numbers in a stack on top. My plan to do this was to separate the negatives and positives into 2 different stacks and then merge them afterwards. #include #include…
user2994363
  • 47
  • 1
  • 4
0
votes
1 answer

Moving dependencies (PK, FK and indexes) from one table to another within the same database in Oracle

Please tell me how can I move dependencies (such as PK, FK and indexes) from one table to another within the same database in Oracle? The second table is a copy of the first, only created later for partition reasons. Thank you in advance! :)
kaileena
  • 119
  • 9
0
votes
1 answer

Avg, partition and where SQL Server 2012

Here is my example SQLfiddle.com. Could anybody explain why AvgQuant is invalid column name? Also SQLfiddle is great tool, but how do I set rounding settings? For example, rounding is not correct in the following example (just remove where…
user1700890
  • 7,144
  • 18
  • 87
  • 183
0
votes
1 answer

MS-Access: Assign records to 4 persons, with each has the same number of records

The task was say I have 4000 (Or n) Customer IDs in cutomer table, and I need to assign them to 4 persons to have each of them taking care of 1000 (or N/4) customer IDs, I tried partition, but it gives me the result so wrong with 5: in each record.…
user2108184
  • 1
  • 1
  • 2
1 2 3
…
99 100