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 …
Read MoreSQL Server
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 …
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 MoreDeadlock 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 MoreScript: Find FillFactor of All Indexes in a Database
This blog post first appeared on SQLMaestros In our previous blog posts, we have seen how to find fragmented indexes in a database and how to defrag them by using rebuild/reorganize. …
Read MoreScript: How to Defragment All The Indexes In a Database
This blog post first appeared on SQLMaestros In our previous blog post, we got to know, how to find out all fragmented indexes in a database. Now we will see how …
Read MoreScript: Find The Fragmented Indexes In A Database
This blog post first appeared on SQLMaestros We do create indexes to improve the search performance of our queries. But over a period of time, because of DML operations (inserts/deletes/updates), the …
Read MoreScript: Find Tables Without Clustered Index
This blog post first appeared on SQLMaestros Before we start fine tuning SQL Server, it is good to make sure all basic best practices are in place. One such best practice …
Read More