When SQL Server uses TempDB when any query does not have enough memory to do its operation, it is called TempDB Spill. Let’s learn today.
Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries.
Question: Where is Table Variable Created?
Answer: On Hard Disk and NOT in Memory.
I suggest you read the following blogs
After the blog posts about temp and regular table, I have received questions about it hence I am writing this blog post about TempDB Logging.
This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
The required was very unique and we were able to solve the problem with the help of READPAST query hint. Comprehensive Database Performance Health Check