GREATEST and LEAST compare several expressions within one row. These typed decimal examples show negative numbers, ties, partial NULLs and an entirely missing row.
SQL_VARIANT_PROPERTY: Inspect Decimal Precision and Scale
SQL_VARIANT_PROPERTY makes underlying types visible. Inspect explicit decimal widths, int, Unicode capacity and a missing variant value.
Spotting Agent Jobs That Run Longer Than Usual
Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.
sp_refreshsqlmodule: Refreshing Views and Procedures After a Table Change
Use sp_refreshsqlmodule to refresh changed table dependencies, inspect stale view columns, and protect stable contracts with schema binding.
SQL SERVER – 2008 – Introduction to Online Indexing Operation
An introduction to online indexing in SQL Server, which lets you create or rebuild an index while the table stays available to your app.
Splitting a URL Into Host, Path and Query String in T-SQL
Practice splitting a URL into host, path, and query values with T-SQL string functions, SQL Server 2025 regex, and ordered parameter rows.
Named Instances and Default Instances
Named instances and default instances differ in connection strings, ports, SQL Browser discovery, and the operations each one needs.