It’s wise to set SQL Server file autogrowth to a set number rather than the default percent. That is because the percent setting can end up growing your file very large. The larger your file, the larger that percent will be. It’s better to set your file autogrowth to a set number and keep an eye on it for proper maintenance.
Start by right-clicking the database in SSMS and choosing Properties. Then in the “Database Properties” window, choose Files. Click the ellipses under the “Autogrowth” column (blue arrow below).
The “Change Autogrowth for …” window will pop up. Under File Growth, you can click on the “In Megabytes” radio button and set a fix amount.
It’s as easy as that.
If for some ODD reason you want to disable Intellisense in SQL Server Management Studio, there is a very easy way to do so.
How to Enable or Disable Intellisense in SSMS
Open SSMS – Click on Tools, Options, Expand Text Editor, Transact – SQL, and then click on Intellisense (check screenshot below)
It’s as simple as that! If you are trying to enable / disable to refresh the Intellisense cache because you have the red squiggly underline in your T-SQL, check out my post here to show you an easier way to refresh your Intellisense cache in SSMS.
I recently created a database called “testDB” and when I typed “USE testDB” in the SSMS Query window it gave me a little red squiggly underline (see below snapshot).Why did this happen when I just created a new database? That’s because the local IntelliSense cache hasn’t updated yet.
How to Refresh IntelliSense Cache in SSMS
If you want to force the IntelliSense Cache to update, go to Edit, then IntelliSense, then click “Refresh Local Cache.” (See snapshot below)
That should refresh your IntelliSense Cache and remove all those annoying red squiggly underlines!
The default layout in SSMS is too restrictive. I’m always having to scroll up and down and it gets pretty annoying. So I made a simple settings change that gives me more “real estate.”
The configuration for this is quite simple: Go to Tools, then click on Option, expand Query Results, expand SQL Server, click on Results to Grid and make sure the “Display results in a separate tab” is checked. (see image below)
You might have to restart SSMS or open another session for the new layout to take effect. Enjoy!