This Table Partitioning Quiz asks whether a query for last month runs faster once a sales table is partitioned by month. The answer is only when the filter lets SQL Server skip partitions. A tested script shows the partition count, the reads, and a partition SWITCH.
Loading a Fact Table Without Blocking Reports
Loading a fact table without blocking reports calls for isolated staging, aligned partition switching, short locks, and a tested reader path.
Partitioning a Large Fact Table
Partitioning a large fact table can simplify loading and retention when boundaries, aligned indexes, and switch rules are designed together.
SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
A simple Table Partitioning tutorial for SQL Server 2005 that shows, step by step, how to horizontally partition a database table across two filegroups.
Adding a New Year Partition Before the Calendar Rolls Over
Add a new year partition before January data arrives by checking boundaries, preparing NEXT USED, splitting an empty range, and scheduling the work.
Designing Tables for High Insert Rates
High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.