GitHub

fnc-table-partition.sql

select tmp.is_mr_add_partition3('tmp.is_mr_partition_SUBS_ACTIVATION', 20210101, 20210102, 'd', 5) CREATE OR REPLACE FUNCTION tmp.is_mr_add_partition3(prm_tbl text, prm_start integer, prm_end integer, ...
LinkedIn

Table Partitioning in SQL Server – The Basics

I am not an expert in table partitioning, but I hope it will be useful to other new developers to read about my experiences, the mistakes I made, what I learned, how I researched new solutions and how ...
GitHub

sp_partition_managment.sql

1. Verifies the correct number of partitions exist in the tail as defined by @days_to_keep_data 2. Verifies the partitons have no gaps in the tail (partitions older than the current partition), each ...
LinkedIn

Understanding RANK() and PARTITION BY in SQL

Structured Query Language (SQL) is a powerful tool for managing and querying relational databases. When dealing with large datasets, it's often necessary to rank and analyze data to gain valuable ...