Sometimes we need to increase or
decrease font size of text in the query execution for presentation etc purposes
in sql server management studio (SSMS) 2014, 2012, 2008 and 2005. We can change
it permanently from settings:
How
to increase or decrease font size in the query execution plan in Sql server
management studio (SSMS):
Step 1: Go to Tools -> Options
as shown in following diagram:
 |
| SSMS Setting Options |
Step 2: Go to Environment ->
Fonts and Colors
 |
| EXECUTION Plan Font Size Change Setting SSMS |
Step 3:
a.
In Show Settings for drop down choose Execution Plan.
b.
In the display items drop down choose Text
c.
In the size
drop down choose any size which you want to set.
d.
After setting
click on OK button.
Step 4: A warning message will pop
up:
 |
| Execution Plan Font Size change wraning Message |
Click on Ok button.
Step 5: Restart your sql server. If
you don't know how to restart sql server go through this link:
Re-generate the graphical execution
plan. After this your font size in the graphical query execution plan will
increase or decrease permanently:
 |
| SSMS Execution Plan With Larger Font Size |
No comments:
Post a Comment