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