Forwarded Records in heap tables still puzzle many SQL Server users, years after I first wrote about them. Here is what they are and how to fix them.
SQL SERVER – What is Tail-Log Backups?
Tail-Log Backups capture the end of an available transaction log before a restore. I assess them within the intended recovery chain.
SQL SERVER – Error 1324. The folder path ‘Program Files’ contains an invalid character.
Error 1324. The folder path ‘Program Files’ contains an invalid character. Let us fix the error with the help of the solution in the blog.
How to Shrink TempDB Without SQL Server Restart? – Interview Question of the Week #163
A client ran the shrink command again and again, but TempDB would not get any smaller. Here is how to Shrink TempDB without a SQL Server restart.
SQL SERVER – The Automatically Saved Settings file NewSettings.vssettings Cannot be Found
After cleaning up some data from my user profile, when I launched SQL Server Management Studio 17.4, I got an error. related to automatically saved settings.
SQL SERVER – Puzzle – How Does Table Qualifier Work in INSERT Statement?
You can use a table alias in SELECT just fine, but how does a Table Qualifier work in the column list of an INSERT statement? Try this short puzzle.
SQL SERVER – Why SQL Server Service is Stuck in Starting / Change Pending State?
A reader’s SQL Server service was stuck in Starting / Change Pending in Configuration Manager. Here is what the ERRORLOG showed in this variation and the fix.