SQL Server Archives - SQLServerGeeks

LIVE Troubleshooting on Production Server – Plan Cache Bloating

March 4, 2021 - by admin - Leave a Comment

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin. SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter Thanks for reading & watching. …

SQL Server

LIVE Troubleshooting on Production Server – Physical vs Logical IO

March 1, 2021 - by admin - Leave a Comment

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin. SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter Thanks for reading & watching. …

SQL Server

SARGability and Selectivity in SQL Server

February 25, 2021March 1, 2021 - by admin - Leave a Comment

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin. SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter Thanks for reading & watching. …

SQL Server

Finding Expensive Lookups in SQL Server

February 24, 2021 - by admin - Leave a Comment

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin. SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter Thanks for reading & watching. …

SQL Server

Why are Missing Index Hints Missing

February 22, 2021February 24, 2021 - by admin - Leave a Comment

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin. SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter Thanks for reading & watching. …

SQL Server

Extended Events Tips & Tricks (GUI)

September 8, 2020September 8, 2020 - by SSG Admin - Leave a Comment

This blog post first appeared on SQLMaestros. In this video blog post, you will see a couple of tips and tricks related to SQL Server Extended Events Graphical User Interface. You will …

SQL Server

SSMS & ADS – July 2020 Release

July 28, 2020July 28, 2020 - by Amit Bansal - Leave a Comment

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 …

SQL Server

Double Read – Reading The Same Record Twice

July 8, 2020July 8, 2020 - by Amit Bansal - Leave a Comment

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 …

Scripts / SQL Server

Script: Find Top 10 CPU Intensive Queries

July 8, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

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 …

Scripts / SQL Server

Script: How to Identify Whether Optimizer is Reusing the Plans or Not

July 7, 2020July 24, 2020 - by Ramesh Satya - Leave a Comment

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 …