Skip to content

Commit e3418eb

Browse files
committed
Add new useful info in SSMS tips
1 parent fc57c13 commit e3418eb

5 files changed

Lines changed: 28 additions & 3 deletions

SSMS/SSMS_Tips.md

Lines changed: 28 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,8 @@ Content:
3333
29. [SSMS Default Reports](#29)
3434
30. [Live Query Statistics](#30)
3535
31. [Searching in Showplan](#31)
36-
32. [Reference](#reference)
36+
32. [](#32)
37+
33. [Reference](#reference)
3738

3839

3940
Great thanks to:
@@ -95,6 +96,7 @@ Most useful are:
9596
| `Ctrl + Alt + T` | Display Template Explorer |
9697
| `Ctrl + Shift + M` | Specify values for template parameters |
9798
| `Ctrl + Shift + R` | Refresh local cache |
99+
| `Ctrl + Alt + S` | Include Client Statistics |
98100

99101

100102
<a id="3"></a>
@@ -180,7 +182,7 @@ This behavior can be disabled in SSMS: go to `Tools > Options > Text Editor > Al
180182

181183
<a id="8"></a>
182184
## Client Statistics
183-
When you enable that option for your session, SQL Server Management Studio will give you more information about the client side processing of your query.
185+
When you enable that option for your session (`Ctrl + Alt + S`), SQL Server Management Studio will give you more information about the client side processing of your query.
184186

185187
The Network Statistics shows you the following information:
186188
- Number of Server Roundtrips
@@ -381,6 +383,14 @@ My favorite regex: replace `\t` on `\n, `. It useful in many cases when you have
381383

382384
<a id="24"></a>
383385
## Changing what SSMS opens on startup
386+
The more interesting way to look at this shortcut is to check the various options available with SSMS command line parameters.
387+
To check them, use the following command:
388+
```
389+
C:\> ssms /?
390+
``
391+
392+
![SSMS command line parameters](/SSMS/SSMS_Tips/24_SSMS_command-line_parameters.png)
393+
384394
You can customize SSMS startup behavior in `Tools -> Options -> Environment -> Startup` and hide system objects in Object Explore:
385395
386396
![Changing what SSMS opens on startup](/SSMS/SSMS_Tips/24_changing_what_ssms_opens_on_startup.gif)
@@ -399,7 +409,7 @@ It is useful to create a solution of commonly used SQL scripts to always load at
399409
5. Open Windows explorer and browse to the location of your solution. Copy file location address to your clipboard.
400410
Go back to your SSMS shortcut properties and add within double quotes the location and file name of your solution before the "-nosplash".
401411
402-
This is the complete text within my shortcut properties:
412+
This is the complete text of shortcut properties:
403413
404414
```
405415
"C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe" "C:\Users\taranov\Documents\SQL Server Management Studio\Projects\MySQLServerScripts.ssmssln" -nosplash
@@ -561,6 +571,21 @@ In SSMS 17.2, appear the ability to search table name, index name or column name
561571
More details here: [New in SSMS: Searching in Showplan]
562572
563573
574+
<a id="32"></a>
575+
## Object Explore Details
576+
To bring up the Object Explorer Details pane, use the `F7` shortcut or it can be accessed from `Toolbar -> View -> Object -> Explorer Details`.
577+
578+
![SSMS_Database_Default_Reports](/SSMS/SSMS_Tips/32_object_explore_details_01.png)
579+
580+
![SSMS_Database_Default_Reports](/SSMS/SSMS_Tips/32_object_explore_details_02.png)
581+
582+
You can customize display field hide or unhide it:
583+
![SSMS_Database_Default_Reports](/SSMS/SSMS_Tips/32_object_explore_details_03.png)
584+
585+
You can searched for the keyword `%Country%` and using `%` as a wildcard character.
586+
This tells SQL Server Management Studio to display all the objects that have the word `Country` in their name.
587+
588+
564589
<a id="reference"></a>
565590
Reference:
566591
- [Free Course: SQL Server Management Studio Shortcuts & Secrets](https://sqlworkbooks.com/course/sql-server-management-studio-shortcuts-secrets/) (by Kendra Little)
16.1 KB
Loading
12.6 KB
Loading
34.9 KB
Loading
18.7 KB
Loading

0 commit comments

Comments
 (0)