SQL Server

/SQL Server

LIVE Troubleshooting on Production Server – Plan Cache Bloating

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |March 4th, 2021|SQL Server|Comments Off on LIVE Troubleshooting on Production Server – Plan Cache Bloating

LIVE Troubleshooting on Production Server – Physical vs Logical IO

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |March 1st, 2021|SQL Server|Comments Off on LIVE Troubleshooting on Production Server – Physical vs Logical IO

SARGability and Selectivity in SQL Server

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |February 25th, 2021|SQL Server|Comments Off on SARGability and Selectivity in SQL Server

Finding Expensive Lookups in SQL Server

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |February 24th, 2021|SQL Server|Comments Off on Finding Expensive Lookups in SQL Server

Why are Missing Index Hints Missing

This blog post first appeared on SQLMaestros. Let’s understand a few reasons why SQL Server (sometimes) does not show missing index hints. We are using AdventureWorks2016 database for the demo. Let’s make a copy of Sales.Customer table as Sales.CustomerDup SELECT * INTO sales.customerdup FROM sales.customer Before jumping into the actual query, have a look at [...]

By |February 22nd, 2021|SQL Server|Comments Off on Why are Missing Index Hints Missing

Extended Events Tips & Tricks (GUI)

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 learn things like, Filtering, Grouping, Aggregation, Bookmarks, Saving/Opening Settings, Exporting XEvents data to a table, and more. Overall, the idea is to show you [...]

By |September 8th, 2020|SQL Server|Comments Off on Extended Events Tips & Tricks (GUI)

SSMS & 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 long pending Database Diagram issue has been fixed along with couple of other fixes. There are new features too. Checkout the release notes. For [...]

By |July 28th, 2020|SQL Server|Comments Off on SSMS & ADS – July 2020 Release

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 video. Now, explanation. So why does this happen? Let’s go step by step. Step 1 First, user 1 fires an UPDATE in an explicit [...]

By |July 8th, 2020|SQL Server|Comments Off on Double Read – Reading The Same Record Twice

Script: 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 the right place. sys.dm_exec_query_stats DMV contains all the information about the resource (CPU, Memory, I/O) consuming queries that are currently in the cache. We [...]

By |July 8th, 2020|Scripts, SQL Server|Comments Off on Script: Find Top 10 CPU Intensive Queries

Script: 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 DMV becomes very handy when we are looking out for statistical information related to queries. Upon executing the above DMV, we will see a [...]

By |July 7th, 2020|Scripts, SQL Server|Comments Off on Script: How to Identify Whether Optimizer is Reusing the Plans or Not