The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
SQL SERVER Tools I Use and Recommend (Updated: January 2020)
Here is the updated list for January 2020 of all the tools which I recommend. Do let me know if you use any of the above tools.
SQL SERVER – Resolve WAIT_ON_SYNC_STATISTICS_REFRESH Wait Type
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
SQL SERVER – Script to Find All Columns with a Specific Name in Database
Recently, one of the clients asked me if I have a Script to Find All Columns with a Specific Name in Database. Yes, of course, I do have it.
SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5
I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.
SQL SERVER – SqlServerWriter Missing in vssadmin List Writers Command
After troubleshooting they found that when they run vssadmin list writers command from the command prompt, they are not seeing SqlServerWriter.
How to Recompile Stored Procedure? – Interview Question of the Week #260
Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:
EXEC sp_recompile ‘NameofSP’
Let us read more about it.
SQL SERVER – SQL Server Agent Missing in SQL Server Configuration Manager
In this blog, we would look into a special situation where ONLY SQL Server Agent is missing in SQL Server Configuration Manager.
SQL SERVER – Temp Table vs Table Variable – Cardinality Estimation
I had a very interesting conversation with one of my clients about Cardinality Estimation for Temp Table vs Table Variable. Let us discuss it today.
SQL SERVER – Event ID 7000 – The System Cannot Find the File Specified
This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.