How to debug SQL Server queries

Sometimes queries result is not what you expected or not working at all, finding the error is not easy, especially when you have a huge query which all connected with other stored procedure and functions, in this case, we have to use a debugger which helps us to debug our code line by line. In this video, I try to explain the debugger in a simple example. I hope you find it useful.

Top SQL Server Management Studio (SSMS) Shortcut keys

Working with the keyboard is a lot faster and more productive, in this video, I am going to show you my favorite 22 shortcut keys for SQL Server Management Studio (SSMS).


Basics
-----------
Ctrl + N => New Query
Alt + F4 => Close Window
Alt => Main Menu
Shift + F10 => Context Menu
Alt + Tab => Navigat to other window/tool window
F5 => Execute current Query
Alt + Break => Cancel or Stop current running query
Ctrl + J => List Members (Intelesense)
Shift + Alt + Enter  => Enter/Exit Full screen mode
Shift + ESC => Close current tool window


Bookmars
----------------
Ctrl + K, Ctrl + K => Add/Remove bookmark
Ctrl + K, Ctrl + N  => Next bookmark
Ctrl + K, Ctrl + P => Prev bookmark
Ctrl + K, Ctrl + L  => Clear all bookmarks

Debuggin
-----------------
Alt + F5 => Start/Continue debugging
Shift F5 => Stop debugging
F11 => Step into
F10 => Step over
Shift + F11 => Step out
Ctrl + Alt + Q => QuickWatch

Break Points
-----------------
F9  => Toggle breakpoint
Ctrl + F9  => Enable Breakpoint
Ctrl + Shift + F9 => Remove all breakpoints
Ctrl + Alt + B => BreakPoint Window


Tools Window
-----------------
F8  => Object Expolorer
F4  => Property Window
Ctrl + Alt + A  => Activity monitor
Ctrl + Alt + W, 1 => Display the Watch1 window
Ctrl + Alt + W, 2 => Display the Watch2 window
Ctrl + Alt + W, 3 => Display the Watch3 window
Ctrl + Alt + W, 4 => Display the Watch4 window
Ctrl + Alt + V, L => Display the Locals Window

Misc.
-----------------
Ctrl + Alt + I => Display the Immediate Window
Ctrl + 1 => sp_who
Ctrl + 2 => sp_lock