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.
SQL SERVER – Database Engine TCP Port and Browser UDP Port
I inspect TCP listeners to find the actual Network port in use. A customer wanted a query rather than an assumption.
SQL SERVER – Capturing INSERT Timestamp in Table
A default can insert timestamp values when the caller omits a datetime column. I use a session-local CURRENT_TIMESTAMP example.
SQL SERVER – Logical Processing Order of the SELECT Statement
Logical Processing places DISTINCT before TOP in a SELECT statement. Questions after my video prompted this explanation.
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.
SQL SERVER – What is Logical Read?
A logical read requests a database page through the buffer cache. A customer asked about that measure after my STATISTICS IO video.
SQL SERVER – 3 Different Ways to Set MAXDOP
There are 3 different MAXDOP scopes: instance, database and statement. Readers of my 16-versus-1 demonstration asked where to configure it.