Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.
we figured out that they had slow overall performance because they had TempDB located on the slow drive. Today we will learn how we can move TempDB.
They realized their counter Counter Temp Tables For Destruction Not Working and wanted me to help them. Let us learn about it today.
Comprehensive Database Performance Health Check, and it was about the tempDB. Let us learn today 3 Ways to Know Count of TempDB Data Files.
I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.
After looking at the execution plan, I realized it was actually built for a very simple query. Today let us discuss Memory-Optimized TempDB and Performance.