This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of a train compartment window with a vermilion curtain pulled aside to reveal the countryside

Maximize Execution Plan Space in SSMS With Two Settings

May 23, 2019
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Server Management Studio, SQL Shortcut

To maximize execution plan space in SSMS, send the results to their own tab and switch to full screen mode. This post lists the two settings, the shortcuts that go with them and the zoom controls for a large plan on a small screen.

Read More
Two railway routes meet at the same tunnel with a switch at their junction

How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224

May 12, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server Management Studio, SQL Shortcut

How do you execute a query in SSMS without F5 or the Query Toolbar? An attendee in a private training asked for a unique way, and here is a less known method.

Read More
Options window.

SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS

August 30, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL Shortcut

After a fresh SQL Server 2014 install, CTRL + R no longer hid the results pane in SSMS. These keyboard option steps got my shortcut working again.

Read More
A hand pressing a red-handled dibber board into soil, leaving a neat grid of planting holes

SSMS Code Snippets: Writing Your Own Templates

July 18, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SQL Shortcut

Build SSMS code snippets with editable literals, register your own snippet folder, and use Template Explorer for repeatable SQL scripts.

Read More
Clamp gripping selected fabric strips beside loose unselected strips

Object Explorer Details in SSMS: Bulk Scripting and Quick Counts

July 8, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL Shortcut, System Object

Press F7, select a group of tables and script them in one go. Then check the grid’s row counts with two short queries.

Read More
A worn footpath cutting diagonally across a park lawn between two paved paths, a distant figure walking on it.

SSMS Keyboard Shortcuts Worth Learning

February 2, 2014
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Server, SQL Server Management Studio, SQL Shortcut

SSMS keyboard shortcuts for execution, comments, results, and Object Explorer remove repeated clicks while keeping query context visible.

Read More
A row of wall switches on wooden plates, the middle switch red and the others muted gray and cream.

Commenting Out Code: Testing Safely in SSMS

August 25, 2013
Pinal Dave
SQL Tips and Tricks
SQL Delete, SQL Scripts, SQL Server Management Studio, SQL Shortcut

Commenting Out Code is the quickest way to switch off part of a script while you test the rest. This post covers the SSMS shortcuts, testing one WHERE filter at a time, the trap of GO inside a block comment, and a safety note to leave above a DELETE.

Read More
Previous 1 2 3 4 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com