Work with spatial data in SQL Server using geography, geometry, matching SRIDs, distance queries, and an index designed for location searches.
SQL SERVER – Introduction to Extended Events – Finding Long Running Queries
After reading Jonathan Kehayias on Extended Events, I added them to my performance tuning course. An introduction, with a way to find long running queries.
datetime: Read Its Fractional-Second Rounding
datetime does not preserve every millisecond despite displaying three fractional digits. These typed conversions show its legacy rounding alongside the original datetime2 text.






