geometry STIsClosed does not establish simplicity. These three complete line descriptions compare endpoint closure with self-intersection.
geometry STEnvelope: A Bounding Box Includes Extra Space
geometry STEnvelope can include points outside the original shape. These two triangle tests keep envelope membership beside exact containment.
GROUPING SETS: Choose Nonhierarchical Subtotals Explicitly
GROUPING SETS lets me choose independent subtotal combinations instead of assuming one hierarchy. I list the groups the report needs explicitly. That can exclude detail rows while retaining summaries across different dimensions.
EXP and LOG: Read Approximate Inverse Calculations
EXP and LOG can undo each other mathematically, but their SQL float calculations remain approximate. Keep a deliberate display scale and test only the permitted logarithm domain.
CEILING and FLOOR: Negative Values Change the Direction
CEILING and FLOOR follow numeric order even below zero. This example compares both boundaries with truncation and explicitly defines its displayed decimal types.
NCHAR: Build Unicode Characters From Integer Codes
NCHAR builds a character rather than formatting a number. Preserve source codes and distinguish unsupported values from missing input.
SQL SERVER – 2005 – Dynamic Management Views (DMV) and Dynamic Management Functions (DMF)
Dynamic Management Views and Management Functions show what SQL Server is doing right now. The two scopes, the main categories and where to start.