My Humble SQL Tips

Recurring Tasks In the  previous posts  of this series I both explained the concept of the sliding window partition as well as the way I h...

It's been a long while since I've worked on this - and believe me I want to as every month I'm spending too much time manually s...

In my  previous post  I shared a stored procedure that dynamically creates and executes a restore log script in order to ease the recovery o...

UPDATE: 22 Jan 2014 - Fixed some bugs, added multi-file support and added a few notes Every month I need to maintain the various sliding p...

We've been trying to tighten up the database release process at work. This involves lots of big and small changes including things like ...

Sliding Partition Window Concept Before we continue, let’s remind ourselves of what the Sliding Partition Window is and what it gets u...

Introduction Table partitioning, as it was introduced in SQL Server 2005 Enterprise Edition, is an incredibly useful feature. It enhances ...

I've mentioned a set of DMV queries that I use in a previous post on this blog . I've been chopping and changing the base set of que...

The stored procedure /********************************************************************************* UPDATE: Bug fixes and increased ...

I find that one (well, actually, one of many) really annoying things of restoring databases to different servers is the orphaned user! I am ...