Amit Bansal

/Amit Bansal

About Amit Bansal

This author has not yet filled in any details.
So far Amit Bansal has created 6 blog entries.

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

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

Deadlock Due To Bookmark Lookups

Deadlock 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 test data to play with. use WideWorldImporters GO -- create a opy of sales.customers select * into sales.customers2 from [...]

By |July 7th, 2020|SQL Server|Comments Off on Deadlock Due To Bookmark Lookups

Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging

This blog post first appeared on SQLMaestros . Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging In this blog post, we will see how SQL Server optimises Tempdb logging for faster CRUD operations. For the purpose of this tutorial, we will perform the same operations in a regular user database versus Tempdb, and note down [...]

By |July 2nd, 2020|SQL Server|Comments Off on Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging

SARGABILITY, CAST, CONVERT & More…

This blog post first appeared on SQLMaestros . The phrase Sargability is quite popular in SQL Server world. Wikipedia says: “In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can take advantage of an index to speed up the execution of the query. The term [...]

By |July 2nd, 2020|SQL Server|Comments Off on SARGABILITY, CAST, CONVERT & More…