Category "database-partitioning"

Using 'on conflict' with a unique constraint on a table partitioned by date

Given the following table: CREATE TABLE event_partitioned ( customer_id varchar(50) NOT NULL, user_id varchar(50) NOT NULL, event_id varchar(50) NOT

Using 'on conflict' with a unique constraint on a table partitioned by date

Given the following table: CREATE TABLE event_partitioned ( customer_id varchar(50) NOT NULL, user_id varchar(50) NOT NULL, event_id varchar(50) NOT

BigQuery partition pruning while using analytical function as part of a view, on a DATETIME field with DAY granularity

I am trying to use analytical functions (e.g. FIRST_VALUE), while still benefiting from from partition pruning. This while the table is partitioned on a DATETIM

How to create composite partition in SQL Server?

I want to create a sample database using composite partition. I know about Range Partition and List Partition. But, I don't have enough knowledge about Hash Val