statistics

External Article

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

External Article

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

Technical Article

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

External Article

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

T-SQL Tuesday #155 –The Dynamic Code Invitation

By

Apologies for the late invitation. A minor snafu has me hosting again. This is...

Daily Coping 6 Oct 2022

By

Today’s coping tip is to remind yourself that you are enough just as you...

What you can do is based on more than your direct permissions.

By

What you have access to is not just what you have direct permissions to....

Read the latest Blogs

Forums

OP identification

By kaj

In lengthy discussions and in developing trial and error scenarios I sometimes find it...

Windows SQL Server 2012 on Raspberry Pi

By kinropags

I am wondering whether or not there is a way to get Windows SQL...

What's the CEIP?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the CEIP?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers