Very clear explanation of things we use daily and may never think about. Former Republican governor of Wisconsin Scott Walker should have read this a year ago.

I'll look into partitioned views. The server will be decommissioned after this has finished.

Thanks Jeff!

Thanks sgmunson and Arsh,

"No easy answer" is exactly the point. We're choosing to choosing to move the data to the new server. We've tested for Cognos compatibility and...