Spatial Index Diagnostic Procs – The Rest of the Story
I've devoted the last few blog entries to describing what's in that spatial index analysis proc output and how to use it and interpret the
I've devoted the last few blog entries to describing what's in that spatial index analysis proc output and how to use it and interpret the
A little more about the query sample that gets fed into the spatial index procs. Query sample is a singleton geometry or geography. It's not
Last post discussed the filters. The procs report some raw numbers and some derived numbers. Here's a cheat sheet, although the info is all in
The spatial index diagnostic procs' most enlightening pieces of information have to do with the filter counts and efficiencies reported at the end of the
I've been looking at the spatial index stored procedures (sp_help_spatial_geography_index_xml and friends) a little harder recently, in an attempt to help answer two questions. 1.
Sorry to appear after a blog drought with theory meta-type blog entries. Too much time at conferences pondering technologies, I guess. The "relational database bigots"
I've been following the ADO.NET Entity Framework since its inception. Never did buy the idea about it being "more than an ORM", thought it was
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.