Things you now know

The latest "chain letter" type topic to wend it's way through the blogsphere is "things you now know" and I've been tagged. Here's some things that I now "know" (or opinions I now have) that I wished I'd known earlier in life. I present them without explanation because after all, they're opinions. In general, software […]

Spatial Indexes in SP1, almost no hints required

On experimenting with the CTP of SQL Server 2008 SP1, I found that there were some changes made to the costing algorithm, vis-a-vis spatial indexes. In the RTM version, spatial indexes weren't uses as often as they could be, because the query costing was too high compared to the spatial filters. This made programmers resort […]