A client clicked Browse for more in SSMS and the Network Servers tab was empty. Here is how we narrowed it down and what caused it.
How to Change Fill Factor in SQL Server – Interview Question of the Week #080
It is surprising to see that lots of people do not know that SQL Server Fill Factor 0 (which is the default value when SQL Server is installed) is equal to value as 100.
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Lost or corrupted your log file? Learn how to attach an MDF data file without the LDF log file, using T-SQL or SQL Server Management Studio.
SQL SERVER – Maintenance Plan Folder Missing Under Management in SQL Server Management Studio
A reader wanted scheduled backups on SQL Server 2016 but found the Maintenance Plan Folder Missing under Management in SSMS. Here is my answer.
SQL SERVER – System Objects Not Visible in SQL Server Management Studio
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 – 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.
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.