Notes on SQL

Random articles from a puzzled DBA

In a previous article I showed a basic example of Partition Switching, using animal names ( While not a realistic example for everyday use it did get the principles across. However, certainly in my experience, partitioning is normally dependent upon a number – usually a date. In this article I’ll create a partition process that …

Continue reading