hierarchyid GetDescendant can generate a sibling location before, after or between existing bounds. This read-only example computes paths without inserting records or guaranteeing allocation.
Partition Stats Permissions: A SQL Server 2025 CU9 Counterpoint
A controlled SQL Server 2025 CU9 test separates partition metadata visibility from access to table rows. Compare the documented permission pair with observed grant behavior, and keep the build-specific result within its measured scope.
STARTUP_STATE: Check Whether an Extended Events Session Is Running
STARTUP_STATE controls automatic startup after SQL Server starts, while current session state tells whether an Extended Events session is running now. Compare both states and verify an event-file capture before assuming that a setting started the session.
SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID
On Denali I saw many negative ObjectID values in sys.all_objects. Here is how I found out that each local temp table gets a negative ObjectID.
STCurveToLine: Convert Curves to Linear Approximations
STCurveToLine approximates circular curves with linear geometry. Compare curve, polygon, point, empty and NULL results by their type and state.
SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big
Why did the model database log file grow every day with no activity? The reader was backing up the model database every night. Here is the proof.
SQL SERVER 2008 – 2012 – Declare and Assign Variable in Single Statement
Since SQL Server 2008 you can declare and assign variable values in one statement. This inline assignment saves lines of code, yet I rarely see it used.






