Quiz on SSMS Shortcuts and Secrets

Part of "SQL Server Management Studio Shortcuts and Secrets (1 hour 30 minutes)"

Page content

Grab a pen and notepad, and jot down your answers as you go, then check your answers at the key at the bottom of the page.

Questions

Q1. Which of the following executes a query?

This isn’t the *only* way… but it’s my favorite

  1.  CTRL + R
  2.  CTRL + U
  3.  CTRL + X
  4.  CTRL + E

Q2. What does CTRL + TAB do?

  1.  Cycles between open query files / sessions
  2.  Brings up perfmon.exe with common SQL Server counters
  3.  Cycles between different Windows programs
  4.  Opens the SQL Server Extended Events wizard (which doesn’t call itself a wizard)

Q3. How can you tell if you’re in “completion” mode in intellisense?

  1.  Hitting escape does nothing at all to Intellisense
  2.  Intellisense automatically uses solid shading on a suggestion
  3.  Intellisense is disabled if it’s not in completion mode
  4.  Intellisense automatically uses an outlined box around a suggestion

Q4. How can you get IntelliSense to work with the Dedicated Admin Connection?

  1.  Use a sysadmin account
  2.  Configure the DAC to allow two sessions
  3.  You can’t
  4.  Toggle IntelliSense off and on again

Q5. What is the shortcut for commenting out a block of code?

  1.  CTRL + K, CTRL + I
  2.  CTRL + C, CTRL + K
  3.  CTRL + I, CTRL + K
  4.  CTRL + K, CTRL + C

Q6. How can you script out compression settings on indexes from Object Explorer?

  1. Tools -> Options -> SQL Server Object Explorer -> Scripting settings
  2. Use sp_WhoIsActive
  3. Use SQL Server Profiler with the Tuning template
  4. You can’t

Q7. What shortcut key will bring up the Quick Info column list as shown in this picture?

  1.  CTRL + TAB
  2.  CTRL + K, CTRL + C
  3.  CTRL + K, CTRL + I
  4.  CTRL + UUU

Q8. What the heck is this thing?

  1.  Creates vertical wells for different sessions
  2.  Object Explorer Details
  3.  Splitter bar / split panes
  4.  This draws a new area for pinned tabs

Q9. Which regular expression allows you to find and replace tab characters?

  1.  /t
  2.  /
  3.  /n
  4.  /tab

Q10. What does CTRL + L do?

  1.  Generates an estimated execution plan the next time a query is run
  2.  Immediately generates an actual execution plan
  3.  Immediately generates an estimated execution plan
  4.  Generates an actual execution plan the next time a query is run

Scroll down for the answer key 👇

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

Answer Key

  • A1. 4. CTRL + E
  • A2. 1. Cycles between open query files / sessions
  • A3. 2. IntelliSense automatically uses solid shading on a suggestion
  • A4. 3. You can’t
  • A5. 4. CTRL + K, CTRL + C
  • A6. 1. Tools -> Options -> SQL Server Object Explorer -> Scripting settings
  • A7. 3. CTRL + K, CTRL + I
  • A8. 3. Splitter bar / split panes
  • A9. 1. /t
  • A10. 3. Immediately generates an estimated execution plan