How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2008

Posted by Sqltimes
On January 19, 2013
0 Comments

Horizontal table partitioning is first introduced in Sql Server 2005. Table partitioning allows to store data from each period (month, year, etc) to individual partitions (FileGroups). This enables us to perform archiving or purging activities with little data movement. It is a meta data operation, where a partition (of main table) is instantaneously moved to […]

Posted by Sqltimes
On January 12, 2013
0 Comments

I ran into something peculiar today. I have a bunch of standard Sql Agent jobs on my Sql Server 2008. Along with a few maintenance jobs (“Database Integrity Check “, ‘Cleanup History’, etc), there are some business process jobs i.e. ‘Purge’, ‘Expire Old Products’, ‘Process Reports’, etc. Some of these jobs are not listed in SSMS […]

How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2008

Missing Jobs in Sql Agent Listing