Configuring the min and max server memory settings for SQL Server has a number of things to consider prior to making changes. Before we jump into those considerations, let’s learn what the min and max server memory options do. What does the min server memory option do? The min server memory option specifies the minimum … Continue reading Setting Min and Max Server Memory Setting
Ever come across a SQL Server that had 5, 10, or more individual logins for users in it? I have a few times and it made me wonder if whoever had done such a thing realized how much harder they were making the administration of the server by doing this. I suppose some folks start … Continue reading Three Reasons to Use Windows Groups to Manage SQL Server
In an earlier post I listed three tips for using the SQL Server Management Studio user interface. I want to offer three additional tips for SSMS. I think you will find that these ideas will bring additional efficiency and functionality to your use of the interface. The first tip is related to getting more viewing … Continue reading 3 Additional Tips for Using SQL Server Management Studio