• Floats can be useful when the same column needs to be able to hold either large values (lots of numbers before the decimal point) or very small values (lots of numbers after it).

    There are of course loads of pitfalls to be aware of, but in general, so longer as you always round the number to an appropriate number of decimal places then things will work.

    eg in this qotd

    while @i <> 1

    could be something like

    while round(@i,8) <> 1

    However, they are definitely better avoided if there's a reasonable alternative!