BINARY_CHECKSUM helps detect changes in a row. My working example shows how it works and why it misses a value changed from A to B and back to A.
geometry STDifference: Keep the Subtraction Direction
geometry STDifference is directional. Two overlapping equal-area rectangles can produce equal remaining areas while retaining entirely different regions.
SQL Tips – 5 SQL Server Best Practices
5 SQL Server Best Practices worth a quick check, starting with backing up the master database and testing it, and rebuilding indexes online to cut downtime.
SQL SERVER – Check Advanced Server Configuration
How do you Check Advanced Server Configuration values? Turn on show advanced options with sp_configure, run RECONFIGURE, then run sp_configure to list them.
SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010
I presented two sessions at TechInsight 2010 in Kuala Lumpur, Malaysia, from June 29 to July 1, 2010. The best part of the trip was the people and their response.
SQL SERVER – Computed Column – PERSISTED and Storage
How a computed column is created and why PERSISTED and storage go together: persisted columns take more space. Plus links to the whole series.
Inclusive End Dates: Why BETWEEN Misses the Last Day
Inclusive end dates describe whole calendar days, while BETWEEN compares the exact supplied endpoints. A date endpoint becomes midnight when compared with timestamp rows. A guarded disposable fixture makes the boundary conditions explicit.
Spatial Data Types for Beginners
Spatial data types in SQL Server use geometry for planes and geography for Earth; points, polygons, and indexes start with valid coordinates.
SQL SERVER – Find Queries using Parallelism from Cached Plan
A script by Feodor Georgiev that finds queries using parallelism from the cached plan, along with their plans. Please avoid running it on a busy production server.










