geometry STGeometryType identifies the represented shape type, which carries more information than its dimension. I compare single and multiple shapes in one small query. Equal dimensions do not mean that their structures are interchangeable.
SQL SERVER – Running Multiple Batch Files Together in Parallel
I needed SQL code running in parallel for a demo, so I used sqlcmd and start cmd.exe to run multiple batch files together. Can PowerShell do it better?
hierarchyid GetAncestor: Stop at the Root
hierarchyid GetAncestor returns a logical ancestor path. Its zero-distance result is the original node, while a request beyond the root returns NULL.
SQL SERVER – Demo Script – Keeping CPU Busy
A demo script for keeping CPU busy: I wrote this query at an event to simulate high CPU usage, and it pushed CPU from 10% to 80%.
Wait Stats Summary: Every Wait on One Page
This wait stats summary puts every wait from the series on one page: what it means and the first fix to try. On Night 28 at the Clipboard Diner, the critic finally comes on an ordinary Tuesday. The lesson of the whole series is the same as the story’s: know what normal looks like on your server.
Wait Stats Troubleshooting: From Top Wait to First Fix
Wait stats troubleshooting comes down to one habit: find the top real wait, ask its first question, and try one fix. On Night 27 at the Clipboard Diner, Casey tapes a one-page chart to the fridge. Here is that chart for SQL Server, plus one query that shows your top waits with their share and signal percent.
OLEDB Wait Stats: Linked Servers and Remote Calls
OLEDB wait stats measure the time SQL Server spends in calls to an OLE DB provider, and that usually means a linked server. On Night 23 at the Clipboard Diner, the pie case is empty and Jules crosses the street for every slice. Learn how to find the waiting session, how OPENQUERY filters on the remote side, and when to keep a local copy instead.