Reference Sheet

RDC Shortcuts:

  •  CTRL+ALT+END: Open the Microsoft Windows NT Security dialog box (CTRL+ALT+DEL)
  • ALT+PAGE UP: Switch between programs from left to right (CTRL+PAGE UP)
  • ALT+PAGE DOWN: Switch between programs from right to left (CTRL+PAGE DOWN)
  • ALT+INSERT: Cycle through the programs in most recently used order (ALT+TAB)
  • ALT+HOME: Display the Start menu (CTRL+ESC)
  • CTRL+ALT+BREAK: Switch the client computer between a window and a full screen
  • ALT+DELETE: Display the Windows menu
  • CTRL+ALT+Minus sign (-): Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer (ALT+PRT SC)
  • CTRL+ALT+Plus sign (+): Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer (PRT SC)

 

SQL Trace Flags:

  • 4135 – disables an optimization in the query optimizer. More info – here
  • 4199 – is added to control multiple query optimizer changes previously made under multiple trace flags. More info – here
  • 3004 (3605) – watch zero initialization happening in error log
  • 1806 – temporarily disable instant file initialization
  • 1807 – allow network shared databases – here
  • 2371 – Adjust when SQL auto updates statistics – here
  • 618 – used for minimal logged transactions – here
  • 1222 – used to catch deadlock information – here

 

DMVs:

  • sys.dm_tran_locks – used for locking and blocking

 

SQL Server Build list – here