Double Read – Reading The Same Record Twice
In this blog post, we will observe Double Read Phenomenon in SQL Server. You will see how the same record is read twice in a single SELECT query/operation. First watch this …
Read MoreAuthor: Amit Bansal
Deadlock Due To Bookmark Lookups
In this blog post, we will see how deadlocks can happen in SQL Server due to Bookmark Lookups. Let’s create a dummy table WideWorldImporters & associated indexes. This will be our …
Read MoreFaster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging
In this blog post, we will see how SQL Server optimises Tempdb logging for faster CRUD operations. For the purpose of this tutorial, we will perform the same operations in a …
Read MoreSARGABILITY, CAST, CONVERT & More…
The phrase Sargability is quite popular in SQL Server world. Wikipedia says: “In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine …
Read MoreSQL Server Index Internals – Clustered Index Seek (Range Scan)
In this video, you will understand what really Clustered Index Seek means and why it can be misleading, sometimes. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos …
Read MoreTroubleshooting SQL Server IO Performance/Bottleneck – Part 4 – PAGEIOLATCH Wait Type
In this video, you will understand how to use PAGEIOLATCH Wait Type metrics to detect/identify IO slowdown. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to …
Read MoreTroubleshooting SQL Server IO – Part 3 (Most Expensive IO Queries)
In this video, you will understand how to detect/identify most expensive IO queries/workloads. Or in other words, how to find out queries that are causing maximum IO in SQL Server (Top …
Read MoreTroubleshooting SQL Server IO – Part 2 (Avg Disk Sec per Read)
In this video, you will understand how Avg. Disk sec/Read performance monitor counter can be used to identify/detect/compute read latency on slow IO. You can also visit DataPlatformGeeks (DPG) Video Library …
Read MoreTroubleshooting SQL Server IO – Part 1 (sys.dm_io_virtual_file_stats)
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 MoreHow is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1
In 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 More