statistics

Customizing Statistics Histogram in SQL Server 2019

  • Article

The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL Server engine, though many DBAs and developers know that periodically we might need to update those statistics to ensure good performance of queries. SQL Server 2019 gives us more options.

2019-04-01

3 reads

Statistics in SQL: Student’s t-test

  • Article

Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test suitable for students. In fact it was William Sealy Gosset, an Englishman publishing under the pseudonym Student, who developed the t-test and t distribution in 1908, as a way of making confident predictions from small sample sizes of normally-distributed variables. As Gosset's employer was Guinness, the brewer, Phil Factor takes a sober view of calculating it in SQL.

2017-10-12

3,767 reads

Statistics in SQL: Simple Linear Regressions

  • Article

Although linear regressions can get complicated, most jobs involving the plotting of a trendline are easy. Simple Linear Regression is handy for the SQL Programmer in making a prediction of a linear trend and giving a figure for the level probability for the prediction, and what is more, they are easy to do with the aggregation that is built into SQL.

2017-06-22

5,131 reads

Statistics in SQL: Kendall’s Tau rank correlation

  • Article

Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating correlation, regression and variance on large quantities of data. It just isn't always immediately obvious how. In the second of a series of articles, Phil factor shows how calculating a non-parametric correlation via Kendall's Tau or Spearman's Rho can be stress-free.

2017-06-20

3,513 reads

Blogs

The Microsoft Power Platform

By

The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow....

From Evangelist to Advocate

By

It’s time for a little bit of change to occur. I am no longer...

Database File Changes

By

Data professionals around the globe are frequently finding themselves occupied with figuring out why...

Read the latest Blogs

Forums

Building a table based on another one(s)

By itmasterw 60042

Hi, We have 3 people that answer the phones to help our customer with...

Best way to find if string is whitespace

By BOR15K

I appreciate it is a trifling question and yet. One of our sites organises...

How to measure Latency between App and database server

By vsamantha35

Hi All, We have SQL Server instance running on a VM. Now we wanted...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers