geometry STIsValid checks whether a spatial instance satisfies the validity rules for its geometry type. I use two parsed lines to separate those questions. Successful construction alone does not establish that a shape is valid.
How to Learn a New SQL Server Release Quickly
Evaluate new SQL Server features with a focused reading plan, version checks, three relevant experiments, and a record of operational tradeoffs.
Sequence Gaps: Why NEXT VALUE FOR Skips Numbers
Explain sequence gaps, inspect cached values, test rollback behavior, and separate SQL Server identifiers from gapless numbering.
SQL SERVER – Shrinking Database NDF and MDF Files
Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.
SQL Server 2025 Editions: What Express and Standard Can Do Now
Compare SQL Server 2025 editions, inspect Express and Standard limits, identify the installed edition, and review database portability.
SQL SERVER – Fastest Way to Restore Database
A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.
SQL SERVER – MERGE Insert Update and Delete with an Isolated Example
Merge Operations can combine conditional inserts, updates and deletes. I inspect the plan before making any claim about scans or speed.