This puzzle assigns a nine digit number to a varchar(8) variable and gets an asterisk instead of a number. The answer is an implicit conversion that does not fit. The post tests which data types behave this way, which ones raise an error, and how to size the variable.
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.
SQL SERVER – How to Execute the Query Without Using Management Studio?
A client’s security team removed SQL Server Management Studio from the server. Here are simple ways for beginners to run a query without it.