Getting 2008 voting data inside Spatial
When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?

Answer Question   |  March 4, 2013  3:16 PM
SQL Server 2008, SQL Server Spatial Data

Spatial query optimizing
I have a development machine and a production machine with identical databases, but I’m getting huge differences in execution plans when running a spatial query. First, my development machine: It’s SQL Server Express x64 with Reporting Services running on Win7 with 8Gb RAM. Then my production machine: SQL Server with Reporting Services running on Windows [...]

Answer Question   |  June 2, 2010  11:32 PM
SQL Server, SQL Server Express, SQL Server query optimization, SQL Server Spatial Data

Free Chapter – Beginning Spatial with SQL Server 2008
Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: “Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and [...]

Answer Question   |  July 16, 2009  12:09 PM
Alastair Aitchison, Apress, Free Chapters, SQL Server 2008, SQL Server Spatial Data