Bulletin: August 06, 2020
Follow SQLServerGeeks on Twitter. Hi There, Webinars – Full Length 75 mins Sessions How To Troubleshoot a Slow Running Query. Click Here. When Things go Wrong – Error Handling in SQL …
Read MoreSQLServerGeeks Bulletin: July 30, 2020
#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 MoreSSMS & ADS – July 2020 Release
This 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 MoreSQLServerGeeks Bulletin: July 09, 2020
#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 MoreDouble 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 MoreScript: Find Top 10 CPU Intensive Queries
This 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 MoreScript: How to Identify Whether Optimizer is Reusing the Plans or Not
This 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