python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - table-partitioning

Partitioning existing table doesn't work, why?

I need help with portioning existing table in the Database. I'm using MSSQL server 2017 and I have table called ACD stores data about calls received and it contains hundred of thousands of records and...
test-img

Moe Kronz

sql

sql-server

table-partitioning

Votes: 0

Answers: 1

Latest Answer

I truncated ACD table and drop the clustered index IX_ACD. After that you need to recreate the clustered index on the target partition scheme. It looks like you created the clustered index on the J...
test-img

David Browne - Microsoft

Postgresql - Optimize ordering of columns in table range partitioning with multiple columns range

I am testing with creating a data warehouse for a relatively big dataset. Based on ~10% sample of the data I decided to partition some tables that are expected to exceed memory which currently 16GB Ba...
test-img

smg77

postgresql

composite-primary-key

table-partitioning

range-partitions

Votes: 0

Answers: 0

Is using table partitioning for maintenance on tables that the service broker writes to a good or bad idea?

We have an activated stored procedure that writes errors to a table, which I recently learned is 300GB. To get rid of the 300GB I'm going to save out recent data, then truncate/reseed the table durin...
test-img

mbourgon

sql-server

service-broker

table-partitioning

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs