SQL Server - Blocking and Huge Tempdb

Blocking and Huge Tempdb

https://learn.microsoft.com/en-us/troubleshoot/sql/performance/understand-resolve-blocking

https://support.microsoft.com/en-us/topic/how-to-shrink-the-tempdb-database-in-sql-server-ea0a95c2-eff8-7075-9ee2-2ee42226ca1c

SQL AWAITING COMMAND

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/26f36dd3-e5c0-452f-8513-d8c78c3e3e09/sql-awaiting-command-sleeping-bloking-most-of-the-running-processes-wthout-genrating-any-deadlock?forum=sqldatabaseengine

SQL Server Important Tools Links

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Additionally

Example of GroupBy Clouse

USE [NewAmondsShop]