SQL Server Education (by the geeks, for the geeks)
In this video, you will understand how sys.dm_io_virtual_file_stats can be used to identify/detect/compute read latency on slow IO. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and …
Read MoreIn this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS …
Read MoreIn this video, you will learn why you should not blindly follow the SSMS Missing Index Hints. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to …
Read MoreIn this video, you will learn some quick techniques to identify which stats objects are being used by the SQL Optimizer. These techniques can help you in your query tuning endeavors. …
Read MoreIn this video, you will understand the basics of SQL Server Statistics. How are they created and how are they updated. You can also visit DataPlatformGeeks (DPG) Video Library to watch …
Read MoreIn this video, you will understand the basics of SQL Server Statistics. How are they created and how are they updated. You can also visit DataPlatformGeeks (DPG) Video Library to watch …
Read MoreData Platform Summit 2018 Announced (Bangalore, India) Data Platform Summit (formerly SQLServerGeeks Annual Summit) has become a festival for many. Just like we celebrate Diwali – one of the most popular …
Read MoreIn this video, you will understand the following concepts: SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Memory Clerk You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos …
Read MoreIn this video, I am demonstrating how to track waits stats for a given query/session using Extended Events. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and …
Read MoreIn this video, I am demonstrating the difference between session level waits and task level waits. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download …
Read More