Slava Murygin SQL Server on your fingertips Slava

Slava Murygin SQL Server on your fingertips

Slava Murygin: • Independent SQL Server Consultant in Baltimore – Washington DC Metro Area. • Amateur Astronomer • Amateur Photographer. @Slava. SQL. BLOGSPOT. com

Advanced Level Indexing Transactions Connections Fragmentation Locking/Blocking Plan Cache, Statistics Database and file settings

#SQLFamily Paul Randal Brent Ozar Kimberly Tripp Glenn Berry #SQLHelp Aaron Bertrand Adam Machanic Kendra Itzik Ben -Gan Little Kalen Delaney Erin Benjamin Gail Shaw Stellato Nevarez

9 Sets of scripts for SSMS Ctrl+1 – sp_Who Ctrl+2 – sp_Lock Alt+F 1 – sp_Help Ctrl+F 1 Ctrl+3– 0 Are Free!!!!

To set them Up: Alt-T + O Environment -> Keyboard -> Query Shortcuts

What we can do with that? Ø Not only Stored Procedures – Any query !!! Limitations: Ø Shortcut query’s maximum length is 32 Kb; Ø Query can’t have “Carriage return” symbol (ASCII: 0 x 0 D); Ø SSMS does not support Export/Import of Query Shortcuts;

Demo: Immediate Performance Troubleshooting Ctrl - 3 Ctrl - 6

Demo: Fallow up Performance Troubleshooting Ctrl - 8

Demo: Administration Ctrl – 4, 5, 7, 9, 0, F 1

Brief list of functionalitiess Ctrl+F 1 – Tables; Ctrl+3 – Locks; Ctrl+4 – Indexes; Ctrl+5 – Databases, AGs, Disks, Logins; Ctrl+6 – Running tasks/transactions, Errorlog, Waits, System Information, Configuration; Ctrl+7 – Connections, Network, Jobs/History; Ctrl+8 – Plan Cache Ctrl+9 – Statistics Ctrl+0 – Database objects

Questions?

Content Only Thank YOU Very Much

Slava Murygin SQL Server on your fingertips. @Slava. SQL. BLOGSPOT. com Linkedin: Slava Murygin SVMurygin@gmail. com