A WHILE 1 = 1 loop never ends on its own, so every one needs a planned exit. This post builds a once-a-second sampler with three ways out, a stop flag, a round limit and a time limit, then shows how to stop a loop from a second window and what the recursion limit does.
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.
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.