How to Change Autogrowth in SQL Server 2012

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).

Database Properties Files

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.

SQL Server Autogrowth Settings

It’s as easy as that.

How to Enable or Disable Intellisense in SSMS

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)

Disable or Enable Intellisense in SSMS

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.

How to Refresh 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).use database red errorWhy 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)

refresh ssms intellisense cache

That should refresh your IntelliSense Cache and remove all those annoying red squiggly underlines!

Gain More Real Estate in SQL Server Management Studio

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!

gain more real estate in sql server management studio