SQL Server Education (by the geeks, for the geeks)
#3_July_30_2020_Thursday Hi There, SQL Videos From SSG Where are the estimates coming from? (Cardinality Estimation). Click Here. Power Plan config may affect SQL Server performance. Click Here. SQL Videos From Microsoft …
Read MoreThis blog post first appeared on SQLMaestros SQL Server Management Studio 18.6 and Azure Data Studio July 2020 release, 1.20. Your favourite SSMS has been updated again. Version 18.6 is released. The …
Read More#2_July_09_2020_Thursday Hi There, New Blog Posts • Double Read – Reading The Same Record Twice. Watch a two-minute video on Twitter. Also read the full blog post. Click Here. • Deadlock …
Read MoreIn 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 MoreThis blog post first appeared on SQLMaestros If you want to find the top ‘n’ queries that are currently in the cache, which are consuming more CPU, then you are at …
Read MoreThis blog post first appeared on SQLMaestros If you want to identify non parameterized queries that are hogging your SQL Server plan cache then you are at the right place. sys.dm_exec_query_stats …
Read More