Expose hidden characters with DATALENGTH and UNICODE, clean known whitespace safely, and add a constraint to prevent recurrence.
hierarchyid GetDescendant: Insert Between Siblings
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.
SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion
The request failed or the service did not respond in a timely fashion: SQL Server would not start after TechEd. The event log and our password policy explained it.
VAR and VARP: Choose the Variance Denominator
VAR and VARP describe sample and population variation. Keep observation count and missingness visible when reporting their results.
Checking 32-Bit Leftovers: Linked Server Providers and ODBC Drivers
Find 32-bit dependencies in linked servers, Agent steps, SSIS execution choices, and Windows ODBC drivers before a server move.
DMV Snapshot Deltas for a Query Activity Interval
DMV snapshot deltas show counter growth for cached statements that survive two observations. Compare their identities and report missing coverage before ranking activity.
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.