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 guarded control knob and a separate lever on a wooden document machine beside neatly stacked cards.

Debug Button in Older SSMS: SQL in Sixty Seconds #020

July 11, 2012
Pinal Dave
SQL Video
SQL Deprecated Feature, SQL in Sixty Seconds, SQL Server Management Studio, SQL Shortcut

The Debug button in older SSMS could be mistaken for Execute, and the debugger is gone from current versions. This page keeps the 2012 episode and tests four ways to debug T-SQL without it on SQL Server 2025: parse only, error line numbers, progress messages and the OUTPUT clause.

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
Gouache painting of a branching ribbon connecting grouped paper strips on a wooden clipboard and in a drawer.

Comment T-SQL in SSMS: SQL in Sixty Seconds #019

July 4, 2012
Pinal Dave
SQL Video
SQL Coding Standards, SQL in Sixty Seconds, SQL Server Management Studio, SQL Shortcut

You can comment T-SQL in SSMS with a keyboard shortcut, a toolbar button or the Edit menu. The tests here show nested block comments, an UPDATE that lost its WHERE clause, a dangling comma after a commented column, and an unclosed comment, on SQL Server 2025.

Read More
An adjustable curtain rod aligns repeated mounting holes before the curtains are fitted

Filling Template Parameters in SSMS With Ctrl+Shift+M

May 12, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Variable

Template parameters save you from typing one value in four places, but they only paste text. Here is what that means in practice.

Read More
Two connected marquetry stations remain intact while a sliding handle marks the active station.

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

The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.

Read More
A leaf stencil taped to a plaster wall beside three identical painted sage leaves, a paint sponge on a saucer.

Templates and Snippets in SSMS

February 25, 2008
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Scripts, SQL Server Management Studio, SQL Shortcut

Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.

Read More
SQL SERVER - 2005 - Open SSMS From Command Prompt - sqlwb.exe Example

SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example

October 5, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Utility

Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.

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

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