SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.
SQL SERVER – 5 Performance Optimizations Must Do for TempDB
We fixed quite a lots of things at customer place with regards to TempDB and he finally was able to get “the Flash” fast performance.
When Was SQL Server Last Restarted? – Interview Question of the Week #225
Question: When Was SQL Server Last Restarted?
SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation
Once upon a time, I was trying to remove TempDB database additional files, but it was not working. In this blog I would explain the steps needed fix Msg 2555: Cannot move all contents of the file to other places to complete the emptyfile operation.
SQL SERVER – FCB::Open Failed – TEMPDB Files Fail to be Created with Error: “CREATE FILE Encountered Operating System Error 3”
Once there was an urgent request from my client and they asked my assistance. Without wasting any time, I sent them GoToMeeting invite and started working. In this blog we would learn how to fix FCB::Open failed for TempDB database.
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
Question: When to Use sort_in_tempdb for Rebuilding Indexes?
How to Grow All Files in a File Group Equally? – TRACE FLAG 1117 – Interview Question of the Week #201
Question: How to Grow All Files in a File Group Equally?
Answer: If you are a regular reader of this blog, you would have read my earlier blog post writing about this subject over here: SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags. However, let us try to get an answer to our question in this blog.