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
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
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
SQL SERVER - Switch Between Two Parenthesis using Shortcut CTRL+]

SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]

July 13, 2012
Pinal Dave
SQL Tips and Tricks
SQL Shortcut

A reader shared a handy SSMS tip: press CTRL+] to switch between two parenthesis and jump from an opening bracket to its closing one in long queries.

Read More
SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

July 7, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SQL Shortcut

CTRL+SHIFT+] in SSMS lets you select code between two parenthesis, handy for subqueries and CTEs. Here is how it works at a few cursor positions.

Read More
shortcut

SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut

November 28, 2008
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SQL Shortcut

Many times when I am writing query I have to scroll the result displayed in the result set. Let us learn about the shortcut today.

Read More
SQL SERVER - Query Analyzer Shortcuts - Part 2

SQL SERVER – Query Analyzer Shortcuts – Part 2

April 27, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Shortcut

Praveen Barath replied to my Query Analyzer Shortcuts post, explaining why SSMS in SQL Server 2005 feels slower and why its features are worth learning.

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

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