Let us fix error TempDB error: CREATE FILE encountered operating system error 3 (The system cannot find the path specified.)
I am sure by this time you all are aware that Microsoft has announced SQL Server 2022. It will be released sometime next year.
In today’s blog posts that I have written about SORT IN TEMPDB which can be started on this topic. My client asked me how to speed up index rebuilding.
A client of Comprehensive Database Performance Health Check asked me the advantages of enabling Sort in TempDB Options. Let us learn.
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.