Amit_Bansal

Home/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

Removing SORT Operator – SQL Server Execution Plans

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

TSQL TOP Clause Deterministic vs Non-Deterministic

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

TSQL WHERE Clause applies after ON Clause

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

Monitoring Waiting Tasks (Groups) in SQL Server

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server CPU Queue

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server Index Union Operation

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server – Non Clustered Indexes have the Clustering Key

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server – What is my query doing?

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

Non Clustered Indexes May Hurt Modification Queries Performance

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SCAN vs SEEK Performance – What to look for?

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server Query Tuning – What is the execution time?

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server Order By Clause – Tricky Behavior

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

Query Tuning – Estimates vs Actual Runtime Statistics

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

Get the Actual Execution Plan from the Plan Cache

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SPID blocking itself in SQL Server

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

Extract Wait Type information from the Execution Plan

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

Deadlock within a single table

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server Deadlock due to Bookmark Lookup

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SQL Server Sort Behavior – Basic yet Tricky

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]

SOS_SCHEDULER_YIELD Wait Type does not show up in Waiting Tasks DMV

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter 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 [...]