Amit_Bansal

/Amit Bansal

About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: https://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

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 6th, 2020|SQL Server|0 Comments

Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging

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 execution time (performance comparison). Thanks to Hugo Kornelis, [...]

By |June 22nd, 2020|SQL Server|1 Comment

SARGABILITY, CAST, CONVERT & More…

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 is derived from a contraction of Search ARGument [...]

By |June 11th, 2020|SQL Server|2 Comments

SQL Server Index Internals – Multiple Index Hints by SSMS

In this video, you will see that SQL Server can, sometimes, recommend more than one index hint for a given query, but it is not so evident. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation [...]

By |September 27th, 2018|SQL Server Videos|0 Comments

SQL Server Index Internals – Clustered Index Seek (Range Scan)

In this video, you will understand what really Clustered Index Seek means and why it can be misleading, sometimes. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth [...]

By |September 26th, 2018|SQL Server Videos|0 Comments

Troubleshooting SQL Server IO Performance/Bottleneck – Part 4 – PAGEIOLATCH Wait Type

In this video, you will understand how to use PAGEIOLATCH Wait Type metrics to detect/identify IO slowdown Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. [...]

By |May 10th, 2018|SQL Server Videos|0 Comments

Troubleshooting SQL Server IO – Part 2 (Avg Disk Sec per Read)

In this video, you will understand how Avg. Disk sec/Read performance monitor counter can be used to identify/detect/compute read latency on slow IO. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope [...]

By |April 25th, 2018|SQL Server Videos|0 Comments

Troubleshooting SQL Server IO – Part 1 (sys.dm_io_virtual_file_stats)

In this video, you will understand how sys.dm_io_virtual_file_stats can be used to identify/detect/compute read latency on slow IO. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your [...]

By |April 20th, 2018|SQL Server Videos|0 Comments

How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1

In this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS & AVG_RANGE_ROWS. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos [...]

By |April 12th, 2018|SQL Server Videos|0 Comments

Missing Index Hints in SQL Server Management Studio

In this video, you will learn why you should not blindly follow the SSMS Missing Index Hints. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. [...]

By |March 28th, 2018|SQL Server Videos|0 Comments

SQL Server Statistics – Are My Stats Objects Being Used?

In this video, you will learn some quick techniques to identify which stats objects are being used by the SQL Optimizer. These techniques can help you in your query tuning endeavors. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to [...]

By |March 27th, 2018|SQL Server Videos|0 Comments

SQL Server Statistics Histogram – Part 1

In this video, you will understand the basics of SQL Server Statistics. How are they created and how are they updated. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video [...]

By |March 5th, 2018|SQL Server Videos|0 Comments

SQL Server Statistics Basics – Part 1

In this video, you will understand the basics of SQL Server Statistics. How are they created and how are they updated. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video [...]

By |March 5th, 2018|SQL Server Videos|0 Comments

SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk

In this video, you will understand the following concepts: SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Memory Clerk Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth [...]

By |December 20th, 2017|SQL Server Videos|0 Comments

How to Troubleshoot a Slow Running Query in SQL Server (Extended Events & Wait Stats)

In this video, I am demonstrating how to track waits stats for a given query/session using Extended Events. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). All DPG members (membership is free) have free access to many learning resources including in-person events, [...]

By |December 14th, 2017|SQL Server Videos|0 Comments

Session Level Waits and Task Level Waits

In this video, I am demonstrating the difference between session level waits and task level waits. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Get new content directly in your inbox - Click here Hope the video was worth your time. Happy [...]

By |December 8th, 2017|SQL Server Videos|0 Comments

SQL Server Wait Types, Queues & Wait Statistics

In this video, I am demonstrating a few common wait types in SQL Server. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. Happy Learning. [...]

By |December 4th, 2017|SQL Server Videos|0 Comments

SQL Server Performance Tuning Master Class, Gurgaon, Sept 2016 – executed successfully in Master style!

Detailed blog post from me coming soon! Meanwhile, here is a short summary! We have a habit of creating history! SQLMaestros delivers 9th Master Class in India. On Sept 26rd, 2016, in Gurgaon, we concluded the Eighth public batch of SQL Server Master Class. This class is based on our most popular course, SQL Server [...]

By |October 3rd, 2016|Assignments|0 Comments

SQL Server Performance Tuning Master Class, Bangalore, May 2016 – executed successfully in Master style!

Detailed blog post from me coming soon! Meanwhile, here is a short summary! We have a habit of creating history! SQLMaestros delivers 8th Master Class in India. On May 23rd, 2016, in Bangalore, we concluded the Eighth public batch of SQL Server Master Class. This class is based on our most popular course, SQL Server [...]

By |August 26th, 2016|Assignments|0 Comments

SQL Server Performance Tuning Master Class, Hyderabad, May 2016 – executed successfully in Master style!

Detailed blog post from me coming soon! Meanwhile, here is a short summary! We have a habit of creating history! SQLMaestros delivers 5th Master Class in India and the first one in Hyderabad. On May 9, 2016, in Hyderabad, we concluded the fifth public batch of SQL Server Master Class. This class is based on [...]

By |August 26th, 2016|Assignments|0 Comments