Home Forums SQL Server 2008 T-SQL (SS2K8) Quert regarding getting the results based on months. RE: Quert regarding getting the results based on months.

  • CELKO (1/2/2013)

    Since SQL is a database language, we prefer to do look ups and not calculations.

    That "we" is undefined and thus meaningless. But people who have to write and run applications in the real world know that the I/O from any lookup is orders of magnitude more overhead than all but the most extreme calculations.

    Apparently CELKO doesn't understand that computers perform billions of mathematical calculations per second.

    Where possible, use calculations when appropriate rather than wasting extremely expensive I/O to do things that can be done with a nanosecond or microsecond calculation.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.