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

Weekly reading #29

By

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...

#PowershellBasics: Get-Help -Online

By

One of the other things I learned from the Powershell class I’m taking this...

Undercover TV Podcast – Scripting Options in SSMS

By

In this episode of the podcast, Adrian looks at the scripting options available in...

Read the latest Blogs

Forums

Used Stored procedure in SSIS with different database name in DEV, Test and Prod

By patla4u

Hi, Can you please give me Idea, how can i use stored procedure in...

How to upgrade to SP3 with multiple named 2008R2 instances on same server

By trhorner

I have a server with two named instances of 2008 R2, SP1.  I have...

Upgrade from SP1 to SP3 on server with two named instances, run upgrade twice?

By trhorner

I have a server with 2008 R2 SP1 using two named instances.  When I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers