Eleni Markou shows how to partition tables in Postgres, SQL Server, and Google’s BigQuery:
When it comes to Microsoft SQL Server things are a bit different as this database system does not support dynamic partitions and so partitioning the table manually can be a huge maintenance issue.
That being said, in order to create a partitioned table a similar procedure to the one previously presented must be followed. This time we will create a monthly partition.
Read on for scripts for each.