geometry STDimension describes dimensionality rather than the number of coordinates. A mixed collection reports its highest-dimensional element.
SQL SERVER – Find Gaps in The Sequence
How do you find gaps in a Sequence of numbers? A reader asked, and two experts, Brian and Tejas, replied with good scripts. Here are both solutions.
SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction
Backup and Restore lessons from my consulting work: conventional backups, split file backups, mirrored backups and the FORMAT clause, each with an example.
REGEXP_MATCHES: Read Matches and Capture Groups
REGEXP_MATCHES returns full matches and captured groups. Read group values and positions, preserve duplicate letters, and check a no-match input.
LIKE ESCAPE: Search for a Literal Percent Sign
LIKE ESCAPE expresses a literal punctuation search. Preserve the distinction between wildcard pattern instructions and stored text.
SQL SERVER – Get Query Plan Along with Query Text and Execution Count
A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.







