Quiz on SSMS Shortcuts and Secrets

I hope she picks the catnip

Q1. Which of the following executes a query?

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

  •  CTRL + R
  •  CTRL + U
  •  CTRL + X
  •  CTRL + E
CTRL + E

Q2. What does CTRL + TAB do?

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

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

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

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

  •  Use a sysadmin account
  •  Configure the DAC to allow two sessions
  •  You can’t
  •  Toggle IntelliSense off and on again
You can’t

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

  •  CTRL + K, CTRL + I
  •  CTRL + C, CTRL + K
  •  CTRL + I, CTRL + K
  •  CTRL + K, CTRL + C
CTRL + K, CTRL + C

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

  • Tools -> Options -> SQL Server Object Explorer -> Scripting settings
  • Use sp_WhoIsActive
  • Use SQL Server Profiler with the Tuning template
  • You can’t
Tools -> Options -> SQL Server Object Explorer -> Scripting settings

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

  •  CTRL + TAB
  •  CTRL + K, CTRL + C
  •  CTRL + K, CTRL + I
  •  CTRL + UUU
CTRL + K, CTRL + I

Q8. What the heck is this thing?

  •  Creates vertical wells for different sessions
  •  Object Explorer Details
  •  Splitter bar / split panes
  •  This draws a new area for pinned tabs
Splitter bar / split panes

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

  •  /t
  •  /
  •  /n
  •  /tab
/t

Q10. What does CTRL + L do?

  •  Generates an estimated execution plan the next time a query is run
  •  Immediately generates an actual execution plan
  •  Immediately generates an estimated execution plan
  •  Generates an actual execution plan the next time a query is run
Immediately generates an estimated execution plan
Back to: SQL Server Management Studio Shortcuts & Secrets (1 hour 30 minutes) > FINAL EXAM and thanks!
Menu