Re: SV: Seeking thoughts/experiences on backing up large amounts (say 50 Petabytes) of data

2008-01-26 Thread Paul Zarnowski
LTO4 is rated at 120MB/s, so I'm guessing you factored in some compression to get that up to 350MB/s. Regardless, using the 350MB/s as a starting point, I think it works out to 1 tape drive being able to move 11PB/yr (just using "PB/yr" makes me cringe). I actually came up with 4.5 tape drive ye

Re: Basic SQL debugging

2008-01-26 Thread Andrew Raibeck
You are on the right track. A couple of things to consider: - The values you are operating on are integral values, so you get integral results. In order to get fractional parts, you need to force the math to floating point mode. This can be done by bringing an otherwise ineffective floating point