The number of rows read shows how many rows a scan or seek touched, and it can be far larger than the rows it returned. This post builds a demo table, compares a scan with two seeks, and explains why a seek can still read too many rows.
Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147
This is when the line numbers in SSMS comes in extremely handy and let us learn in today’s blog post how we can do that. Let us learn today.
Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143
I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.
Default Query Shortcuts in SSMS: Alt+F1, Ctrl+1 and Ctrl+2
The default query shortcuts in SSMS are Alt+F1, Ctrl+1 and Ctrl+2, and each runs a system procedure on the text you select. This post shows what sp_help, sp_who and sp_lock return, why sp_lock has a better replacement, and which keys you can change.
5 SQL in Sixty Seconds Video on SSMS Efficiency
I make my living by Comprehensive Database Performance Health Check and one of the constant struggles which I see of my client is to use SSMS Efficiency.
Custom Query Shortcuts in SSMS: Run Your Own Procedure
Custom query shortcuts in SSMS run a stored procedure of your own on the text you have selected. This post writes a small procedure that explains any session, tests it the way the shortcut calls it, assigns it to a free key, and explains which keys you can use.
Word Wrap in SSMS: Wrap Long Lines of T-SQL
Word wrap in SSMS folds a long line of T-SQL at the edge of the window, so you read it without scrolling sideways. This post shows where to turn it on for every window, how to show the wrap marks, how to switch it for one window, and why it never changes your script.