Piecemeal Database Restore
Produced: 16/10/2016 16:16:00
This is a direct follow up from my last post about filegroups because without those we wouldn’t be able to perform what is called a Piecemeal database restore and, trust me, this is something you want to know how to do.

Continued...
Creating a Partitioned View
Produced: 18/09/2016 09:08:00
This is an alternative to native table Partitioning, and something I would potentially rather use instead whether I have Enterprise Edition or not.

Partitioned Views are also available in any edition, which is always a bonus.

Continued...
Bug: Implementing Incremental Statistics
Produced: 28/08/2016 18:36:00
I’ve covered Incremental Statistics over a couple of posts now and although they are a fantastic feature, there is a bug which you need to be aware of. Luckily it’s by no means a showstopper, more just an annoyance.

Continued...

Continued...
Incremental Statistics Performance
Produced: 21/08/2016 18:33:00
Based on my last post we now know how to create incremental statistics on a partitioned table and I mentioned that it was a massive improvement for performance of maintenance, but just how much?

Continued...
The Awesomeness of Incremental Statistics
Produced: 14/08/2016 18:29:00
I did a post a while ago about why you need to be careful with Sampled Statistics and therefore why a FULLSCAN is really the only reliable way to go… BUT there has always been the problem that a FULLSCAN update can take a VERY long time.

Continued...
Online Partition Index Rebuild
Produced: 07/08/2016 18:26:00
Yet more partitioning stuff… this time it’s the fact that we can rebuild an index on just a single partition of a table… and online. Now that’s handy!!!

Continued...
Individual Partition Compression
Produced: 31/07/2016 18:23:00
To continue with partitioning there’s another good feature to consider which involves combining it with another Enterprise feature… compression.

Continued...
How to Find Partition Range Values
Produced: 24/07/2016 18:19:00
This is something I struggled to put together the first time I needed it because partitioning uses internal tables with some very strange IDs and even stranger links between tables.

Continued...
Quick Guide to Partition Switching
Produced: 17/07/2016 18:16:00
Partition Switching is an incredibly fast way to insert or delete data from a partitioned table and works very well in data warehousing environments, for example in which large overnight loads take place.

Continued...
Partition Elimination in Action
Produced: 10/07/2016 18:13:00
There are many reasons to use partitioning in order to make maintenance easier (stats and reindexing) and allowing for partition switching (fast loading and deleting of data), but there is another which is Partition Elimination.

Continued...
How to Partition a Table
Produced: 03/07/2016 18:10:00
Partitioning is an Enterprise only feature and, if you happen to be lucky enough to be using Enterprise, it can be an incredibly powerful and useful feature.

It’s also pretty simple to implement once you know what you’re doing… and therefore this is a quick guide.

Continued...