Why were system objects not visible in SSMS 2016 when SSMS 2014 showed them on the same instance? A client asked me, and here is the answer.
SQL SERVER – How Much Free Space I Have in My Database?
Free Space inside data files differs from unused space on the Windows volume. I check both when planning growth.
SQL SERVER – Vertical Select Mode feature in SQL Server Management Studio
Balmukund showed me the Vertical Select Mode in SSMS: hold ALT, select a block, then type on every row at once. It works in SQL Server 2012 and later.
Sort Query Using Dynamic Variables Without EXEC – Interview Question of the Week #074
How do you sort query results by a column passed in a variable? Here is how to sort query output dynamically without EXEC or sp_executesql.
SQL SERVER – Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
Event ID 107 says the Report Server Windows service cannot connect to the report server database. Here is how I fixed it.
SQL SERVER – Maintain Carriage Return (Enter Key) in SQL Server 2016 Management Studio While Copy and Paste
Copy grid results with line breaks and paste them: SQL Server 2016 Management Studio drops the carriage returns. Here is the setting that keeps them.
SQL SERVER – Puzzle – Solve Splitting Strings Puzzle
A Splitting Strings puzzle: take a column holding delimited values, split them and return how many values each row has. How would you solve it?