SQL Server Archives - Page 37 of 420 - SQL Authority with Pinal Dave

A local doorway is inspected separately from the longer route beyond the courtyard.

SQL SERVER – Database Engine TCP Port and Browser UDP Port

November 24, 2020

Pinal Dave

SQL Tips and Tricks

Computer Network, SQL Scripts, SQL Server

I inspect TCP listeners to find the actual Network port in use. A customer wanted a query rather than an assumption.

Three vessels retain a supplied tag, an older tag and an empty tag loop.

SQL SERVER – Capturing INSERT Timestamp in Table

November 23, 2020

Pinal Dave

SQL Tips and Tricks

SQL Constraint and Keys, SQL DateTime, SQL Scripts, SQL Server

A default can insert timestamp values when the caller omits a datetime column. I use a session-local CURRENT_TIMESTAMP example.

Repeated source tiles sit beside a distinct selection tray and a separate two-tile jig.

SQL SERVER – Logical Processing Order of the SELECT Statement

November 18, 2020

Pinal Dave

SQL Tips and Tricks

SQL Operator, SQL Performance, SQL Scripts, SQL Server

Logical Processing places DISTINCT before TOP in a SELECT statement. Questions after my video prompted this explanation.

Gouache painting of a cream ribbon running off a counter edge beside a tidy roll of wound cream and vermilion ribbon

Word Wrap in SSMS: Wrap Long Lines of T-SQL

November 13, 2020

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Configuration, SQL Server Management Studio

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.