Index Tuning – Index Column Sort Order (by Amit Bansal)
Not sure whether to call this Query Tuning or Index Tuning, anyway, all that matters is we get improved performance. In this video you will see how that importance of column order in an index, especially the SORT mechanism.
Query Tuning – Implicit Conversion – Part 2 (by Amit Bansal)
This is a follow up video to part 1. In this quick video you will see that SQL Server is better off with explicit conversion at it likes it.
Query Tuning – Implicit Conversion – Part 1 (by Amit Bansal)
In this quick video you will understand the concept of implicit conversions and why are they bad for your query performance. This is Part 1.
How To Enable Global Trace Flags In SQL Server (by Amit Bansal)
In this quick video you will understand how to enable global trace flags.
SQL Server Memory Troubleshooting – Buffer Pool Usage (by Amit Bansal)
In this video you will understand how to find out the memory consumption by buffer pool and break it up further by databases and objects.
RESOURCE SEMAPHORE Wait Type & SQLQERESERVATIONS Memory Clerk (by Amit Bansal)
In this video, you will learn about Resource Semaphore Wait Type in SQL Server and also, it’s relation with SQLQERESERVATIONS Memory Clerk.
SQL Server Parallelism (Part 2 of CXPACKET) (by Amit Bansal)
This video is a follow up to CXPACKET video (Part 1). You will see that SQL Server Query Execution Engine still assign max number of threads (as per the number of cores (up to a max of 64)) even when the DB engine is under severe pressure.
Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats by Amit Bansal
In this video, you will understand the difference between sys.dm_exec_query_stats and sys.dm_exec_procedure_stats
Index Tuning – Index Column Sort Order (by Amit Bansal)
Query Tuning – Implicit Conversion – Part 2 (by Amit Bansal)
Query Tuning – Implicit Conversion – Part 1 (by Amit Bansal)
How To Enable Global Trace Flags In SQL Server (by Amit Bansal)
SQL Server Memory Troubleshooting – Buffer Pool Usage (by Amit Bansal)
RESOURCE SEMAPHORE Wait Type & SQLQERESERVATIONS Memory Clerk (by Amit Bansal)
SQL Server Parallelism (Part 2 of CXPACKET) (by Amit Bansal)
Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats by Amit Bansal
