Great code, thanks!

I would also propose creating a view for this instead of a proc. It fits in with the DMVs provided by SQL and allows for easier joining...

How have you determined if you need redundancy in the past? Based on a user requirement for allowable downtime?

You can do it using the row_number() function if you are using SQL 2005 or 2008

this selects all odd records

;WITH ODD

AS

(SELECT ROW_NUMBER() OVER( ORDER BY NAME) AS Num

FROM MASTER.dbo.spt_values ...

Ok so considering the fact that I have 6 disks to work with and a heavy write work load what would you recommend?

My sql agent account is a local windows account and I would like to keep it as such. How do I assign the job to that windows account? ...