8 Statistical Functions
Statistics are like a bikini. What they reveal is suggestive, but what they conceal is vital.—Aaron Levenstein
There’s a common misconception by many developers—advanced and beginner alike—that SQL Server is unsuitable for performing complex computations. The perception is that it’s really just a data retrieval facility—it’s superb at storing and querying data, but any heavy calculation work must be performed in a 3GL of some sort. Though data management and retrieval are certainly its strong suit, SQL Server can perform complex calculations as well, including statistical calculations. If you know what you’re doing, there are very few statistical computations beyond the reach of basic Transact-SQL.