I think you are making my point for me. If I partition by date, then I only get the benefit of partition elimination when I query using a date....

Yes, I did realize it, and no I don't think partitioning on week_id and using calculated columns has the same effect.

There is an advantage to partitioned views which in my opinion is frequently overlooked, and that is the ability to specify multiple "partition keys", by adding multiple constraints to the...

You could create another account with the same rights as sa and instead of changing the password, just enable/disable that account when needed.

CONVERT should do it -

SELECT CONVERT(decimal(18,2),DATEDIFF(N,'08/14/2009 11:15',GETDATE())/60.00)

You're dividing an integer by an integer so it's returning an integer. Try this instead -

SELECT DATEDIFF(N,'08/14/2009 11:15',GETDATE())/60.00