Understand Statistics in SQL Server for better performance troubleshooting

preview_player
Показать описание
Let us quickly learn about statistics in this session.

📚 ►Recommended sessions:

Watch all my playlists here:
  1. ARSLANOV
  2. SQL Server
  3. Statistics
Рекомендации по теме
SQL Server Statistics 0:21:01

SQL Server Statistics Basics – Part 1 (by Amit Bansal)

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

An Introduction to 0:35:30

An Introduction to Microsoft SQL Server's Statistics

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

SQL Server DBA 0:05:53

SQL Server DBA Interview Questions | When should we update Statistics on SQL Server Database and why

BEST Websites to 0:00:43

BEST Websites to Learn SQL FAST 🏃🏽‍♂️💨

Data Analyst SQL 0:00:36

Data Analyst SQL Question for Beginner

How is data 0:07:04

How is data stored in sql database

SQL Server Query 0:06:07

SQL Server Query Tuning Series - Exploring Update Statistics Sampling Rate @jbswiki #querytuning

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

SQL Explained in 0:02:23

SQL Explained in 100 Seconds

SQL Server Execution 0:08:31

SQL Server Execution Plans - Part 1

Start Learning SQL 0:00:22

Start Learning SQL in 3 Easy Steps

How do SQL 0:12:12

How do SQL Indexes Work

How I use 0:15:30

How I use SQL as a Data Analyst

5 Best SQL 0:00:33

5 Best SQL Websites to Practice n Learn Interview Questions for FREE

SQL Window Function 0:24:55

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

Usage of R 0:51:08

Usage of R in SQL Server for better data understanding

SQL Server Tutorial 0:12:26

SQL Server Tutorial - Understanding data types

SQL Server Performance 4:03:27

SQL Server Performance Essentials – Full Course

What is SQL? 0:04:26

What is SQL? [in 4 minutes for beginners]

How To Read 0:06:45

How To Read SQL Server Execution Plans

Комментарии
Автор

Thank you for your content. I'm exploring mssql internal to preparing some interview about database dev. Blessed to view this

Toan.nguyen
Автор

Hi, I think rebuilding indexes updates the statistics only for the columns that have an index. For example the statistics that were created by "where" statement - they won't be updated when rebuilding indexes.

kirilspasov
Автор

That is a perfect Explanation and on point. Bro I want you to create few Query optimization-related videos. If possible please create videos to understand the Execution plan and other query performance tweaks. Will wait for your new videos as you are on top of my list for MSSQL :). So informative.. Keep it up !

iNtellectual.paradoX
Автор

Very well explained 👏 .. Can you do a video on using sp_blitzcache and sp_blitzindex...It would be helpful for suggestions...or any kind of tools which will make our day so easy.

amarcse
Автор

Can you please make a video on execution plans and operators.

Aanand-mo
Автор

Hello, Thank you and greetings from Bulgaria. Great tutorial.
I would like to ask you - you say we can request bigger sample. Yet it is said that statistics is restricted to one 8K page. So it seems that we can not extend indefinitely. Or am I wrong in some way ??

Also - you mentioned that statistics can be created on a column without an index. Very few people mention that.
So I am now exploring - if we can have just statistics to help us build a query plan, why do we need index/es ?? They are bulky etc. And most important they rely underneath on ... statistics. So seem like that they are like middle man.

Would you like to help me (and the others) on that ?? Thank you.

iliashterev