Skip to content
August 10, 2022
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Amit Bansal

Videos & Webinars

Troubleshooting SQL Server IO – Part 3 (Most Expensive IO Queries)

April 26, 2018December 27, 2019 - by Amit Bansal - Leave a Comment

In this video, you will understand how to detect/identify most expensive IO queries/workloads. Or in other words, how to find out queries that are causing maximum IO in SQL Server (Top …

Troubleshooting SQL Server IO – Part 3 (Most Expensive IO Queries) Read More
Videos & Webinars

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

April 25, 2018December 27, 2019 - by Amit Bansal - Leave a Comment

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. You can also visit DataPlatformGeeks (DPG) Video Library …

Troubleshooting SQL Server IO – Part 2 (Avg Disk Sec per Read) Read More
Videos & Webinars

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

April 20, 2018December 27, 2019 - by Amit Bansal - Leave a Comment

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. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and …

Troubleshooting SQL Server IO – Part 1 (sys.dm_io_virtual_file_stats) Read More
Videos & Webinars

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

April 12, 2018March 30, 2022 - by Amit Bansal - Leave a Comment

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 …

How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1 Read More
Videos & Webinars

Missing Index Hints in SQL Server Management Studio

March 28, 2018December 27, 2019 - by Amit Bansal - Leave a Comment

In this video, you will learn why you should not blindly follow the SSMS Missing Index Hints. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to …

Missing Index Hints in SQL Server Management Studio Read More
Videos & Webinars

SQL Server Statistics – Are My Stats Objects Being Used?

March 27, 2018December 27, 2019 - by Amit Bansal - Leave a Comment

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. …

SQL Server Statistics – Are My Stats Objects Being Used? Read More
Videos & Webinars

SQL Server Statistics Histogram – Part 1

March 5, 2018November 22, 2019 - by Amit Bansal - Leave a Comment

In this video, you will understand the basics of SQL Server Statistics. How are they created and how are they updated. You can also visit DataPlatformGeeks (DPG) Video Library to watch …

SQL Server Statistics Histogram – Part 1 Read More
Videos & Webinars

SQL Server Statistics Basics – Part 1

March 5, 2018March 30, 2022 - by Amit Bansal - Leave a Comment

In this video, you will understand the basics of SQL Server Statistics. How are they created and how are they updated. You can also visit DataPlatformGeeks (DPG) Video Library to watch …

SQL Server Statistics Basics – Part 1 Read More
Events

Data Platform Summit 2018 Announced (Bangalore, India)

February 15, 2018February 15, 2018 - by Amit Bansal - Leave a Comment

Data Platform Summit 2018 Announced (Bangalore, India) Data Platform Summit (formerly SQLServerGeeks Annual Summit) has become a festival for many. Just like we celebrate Diwali – one of the most popular …

Data Platform Summit 2018 Announced (Bangalore, India) Read More
Videos & Webinars

SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk

December 20, 2017March 30, 2022 - by Amit Bansal - Leave a Comment

In this video, you will understand the following concepts: SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Memory Clerk You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos …

SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk Read More

Posts navigation

Previous 1 2 3 4 … 24 Next

Subscribe to SQLServerGeeks

Ad

Virtual Symposium

master classes

SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Subscribe To Our Newsletter

loader

Virtual Symposium

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.