statistics

Basic Concepts of Probability Explained with Examples in SQL Server and R

  • Article

Many organizations have known the fact that data have been evolved from the by-product of corporate applications into a strategic asset [1]. Like other corporate assets, the asset requires specialized skills to maintain and analyze. With modern data analytic tools, for example Python, R, SAS and SPSS, IT professionals can build models and uncover previous unknown knowledge from the ocean of data.

2020-01-27

1 reads

How to Think Like the SQL Server Engine: Using Statistics to Build Query Plans

  • Article

Every index has a matching statistic with the same name, and each statistic is a single 8KB page of metadata that describes the contents of your indexes. Stats have been around (and been mostly the same) for forever, so this is one of the places where SQL Server’s documentation really shines: Books Online has a ton of information about statistics. You honestly don’t need to know most of that – but if you wanna make a living performance tuning, there’s a ton of great stuff in there.

2019-11-21

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

Blogs

Daily Coping 26 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure SQL Database – Greatest and Least TSQL

By

Being in the cloud does have many benefits, from lower administration to fast scaling...

T-SQL Tuesday Retrospective #005: Reporting

By

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....

Read the latest Blogs

Forums

Join to lookup table on multiple columns

By sunsilk10

Hi I have a table Meter and a lookup table LookupTbl I need to...

How to know which index is invalid index on a table?

By 892717952

There are about thirty fields in a table SaleOrderLines, I created some indexes ,...

Thanksgiving 2020

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving 2020

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers