Free Events | Free Resources | Free Video Library
DataPlatformGeeks DataPlatformGeeks
  • Social
    • Subscribe >>
      • Subscribe To Our Newsletter
      • Bulletin Index
    • Twitter
    • LinkedIN Group (Forum)
    • LinkedIN Showcase Page
    • Facebook Group (Forum)
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
    • Telegram Channel
    • Connect With Amit Bansal
  • Blogs
    • Subscribe To Our Newsletter
    • Blogs
    • The Scripts Garage
  • Learning
    • Events >
      • Browse Upcoming Events
      • Suggest Topics
      • Event Feedback
      • Browse Past Events
      • Sample Webinar Recordings
      • Virtual Symposiums >
        • SQL Server 2019 & Azure SQL
        • Azure Analytics & Artificial Intelligence
      • Webinar Recordings
    • Videos >
      • DPG Videos Lobby
      • SQL Server Videos
      • Webinar Recordings
      • SQLShighra
      • Virtual Symposiums Recordings
      • Geek Talks
      • Video Resources
    • Hands-On-Labs >
  • Sponsor Us
  • Resources
    • Event Resources
    • Data & Analytics Resources
    • Event Reports & Chronicle
    • Blogs
  • Conferences
  • About
    • Collaborate With Us
    • DPG Community on Mobile
    • About Us
    • Our Social Channels
    • Contact Us
    • DPG Bulletins
    • Blogs
    • Our Speakers
  • Login

SQL Server Videos Library

Home/SQL Server Videos Library
SQL Server Videos Libraryadmin2021-04-08T10:49:37+00:00

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.
Previous Next

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.
Previous Next

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.
Previous Next

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.
Previous Next

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.
Previous Next

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.
Previous Next

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.
Previous Next

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
Previous Next
  • « Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • …
  • 9
  • Next »
Index Tuning – Index Column Sort Order (by Amit Bansal)
Index Tuning – Index Column Sort Order (by Amit Bansal)
Query Tuning – Implicit Conversion – Part 2 (by Amit Bansal)
Query Tuning – Implicit Conversion – Part 2 (by Amit Bansal)
Query Tuning – Implicit Conversion – Part 1 (by Amit Bansal)
Query Tuning – Implicit Conversion – Part 1 (by Amit Bansal)
How To Enable Global Trace Flags In SQL Server (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)
SQL Server Memory Troubleshooting – Buffer Pool Usage (by Amit Bansal)
RESOURCE SEMAPHORE Wait Type & SQLQERESERVATIONS Memory Clerk (by Amit Bansal)
RESOURCE SEMAPHORE Wait Type & SQLQERESERVATIONS Memory Clerk (by Amit Bansal)
SQL Server Parallelism (Part 2 of CXPACKET) (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
Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats by Amit Bansal
  • « Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • …
  • 9
  • Next »

 

Subscribe to DataPlatformGeeks Newsletter

Ad

Follow us on Twitter

dpg twitter

Subscribe to DataPlatformGeeks Newsletter

Our Knowledge Partners

video courses

master classes

HOL

DPG_linkedin

DPG_fb

recorded webinar

dpg twitter

DPG_linkedin

DPG_fb

Subscribe and get notified about upcoming events, webinars & virtual summits. Also get free learning resources from our learning partners.
loader

Copyright 2019 DataPlatformGeeks | All Rights Reserved | Community initiative by Amit Bansal. (Terms | Disclaimer | Privacy) | Anti-Harassment Policy | Code Of Conduct | Our Social Channels