How I helped a customer get better performance by setting the AUTO_CLOSE Database Option to OFF, and why this setting hurts busy databases.
SQL SERVER – How to Hide Number of Rows Affected Message? – SET NOCOUNT
In this blog post, we are going to talk about how to hide the number of rows affected messages with the help of SET NOCOUNT.
How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089
Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?
SQL SERVER – How to Increase the SSMS Grid Font Size?
Presenting SSMS results to a big room? Zoom does not work on the results grid, but Tools, Options, Fonts and Colors lets you raise the grid Font Size.
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
A client with 86 databases struggled to find one in Object Explorer. A newer SSMS Enhancement lets you filter the Databases node. Here is how it works.
Restore or Attach Database Without Log File – SQL in Sixty Seconds #082
Why would you attach database files without the log file? This SQL in Sixty Seconds video shows how to restore or attach a database with only the MDF.
SQL SERVER – SSMS Error During Restore: No Backupset Selected to be Restored
Restoring a SQL Server 2008 backup in SSMS 2012 gave ‘No backupset selected to be restored’. A reader’s question and what causes this restore error.