SQLServerGeeks 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 MoreArchives: Posts
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 …
Read MoreScript: Find Top 10 CPU Intensive Queries
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 …
Read MoreScript: How to Identify Whether Optimizer is Reusing the Plans or Not
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 …
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
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. While creating or rebuilding indexes, we can …
Read MoreScript: How to Defragment All The Indexes In a Database
In our previous blog post, we got to know, how to find out all fragmented indexes in a database. Now we will see how to defrag indexes. According to Microsoft guidelines, …
Read MoreSQLServerGeeks Bulletin: July 02, 2020
#1_July_02_2020_Thursday Hi There, Here is the all new content-rich SQLServerGeeks Newsletter. New Blog Posts • SQL Server optimizes Tempdb so that your CRUD operations go faster. There are many ways how …
Read More